Exact 1Z0-063 Exam Dumps 2021

NEW QUESTION 1
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter: DB_FLASH_CACHE_FILE= ‘ /dev/f lash_device_1‘,‘ /dev/f lash_device_2‘ How should the D3_flash_cache_size be configured to use both devices?

• A. Set DB_FLASH_CACHE_SIZE=64G.
• B. Set D3_FLASH_CACHE_SIZE=64G, 64G.
• C. Set D3_FLASK_CACKE_SI2E=128G.
• D. db_flash_cache_SI2E is automatically configured by the instance at startup.

Answer: B

Explanation: * Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database Smart Flash Cache” area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by “DB Smart Flash Cache”
/dev/sda – size 32G
/dev/sdb – size 32G
/dev/sdc – size 64G
New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file|device and compute the average latency

NEW QUESTION 2
Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database. Identify the required steps in the correct order.

• A. 2, 4, and 3
• B. 2, 4, 3, and 5
• C. 1, 5, 2, 4, 3, and 6
• D. 1, 2, 4, 3, and 6

Answer: D

Explanation: Step 1 (1): To copy tablespaces from one database to another using transportable tablespace, the source tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source database to target database (using any available methods like scp, sftp, rcp, etc).
Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of the tablespaces that needs to transported using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that needs to be transported, we need to copy the Export Dump file as well as all the datafiles belonging to the tablespaces to be transported to the target database server.
References:
http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/

NEW QUESTION 3
You are connected to a recovery catalog and target database. You execute the command: RMAN> CATALOG START WITH ‘/disk1/backups’;
Which statement is true?

• A. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.
• B. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.
• C. It lists all data file copies, backup pieces, and achieved logs cataloged in the recovery catalog in the/disk1/backups directory and its subdirectories.
• D. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

Answer: D

Explanation: If you have data file copies, backup pieces, or archived logs on disk, then you can catalog them in the recovery catalog with the CATALOG command.
The following command catalogs all files in all of these directories, because /disk1/backups is a prefix for the paths for all of these directories:
CATALOG START WITH '/disk1/backups';
To catalog only backups in the /disk1/backups directory, the correct command is as follows: CATALOG START WITH '/disk1/backups/';
References: https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm

NEW QUESTION 4
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?

• A. The resulting backupset has backup pieces that cannot exceed 300 MB.
• B. RMAN uses multiplexing to perform the backup.
• C. RMAN always performs this type of backup in parallel.
• D. The backup succeeds only if the USERS tablespace is locally managed.
• E. The backup set size is limited to 300 MB.

Answer: A

NEW QUESTION 5
You regularly take backups of your database using RMAN with a recovery catalog. Your database is currently open and the temp01.dbf temp file belonging to the TEMP tablespace is corrupted.
Identify two methods to recover the temp file with the least disruption to database availability. (Choose two.)

• A. Drop the TEMP tablespace, and then re-create it with new temp files.
• B. Restart the database instance to create the temp file automatically.
• C. Take the TEMP tablespace offline, drop the missing temp file, and then create a new temp file.
• D. Add a new temp file to the TEMP tablespace with a new name, and then drop the temp file that is corrupted.

Answer: BC

Explanation: Temp files are a special class of data files that are associated only with temporary tablespaces.
B: After restore and recovery of a whole database, when the database is open, missing temporary tablespaces that were recorded in the control file are re-created with their previous creation size, AUTOEXTEND, and MAXSIZE attributes. Only temporary tablespaces that are missing are re-created. If a temp file exists at the location recorded in the RMAN repository but has an invalid header, then RMAN does not re-create the temp file.
If the temp files were created as Oracle-managed files, then they are re-created in the current DB_CREATE_FILE_DEST location. Otherwise, they are re-created at their previous locations.
C: If a data file becomes missing or corrupted. You must take it offline before you can open the database.
References: https://docs.oracle.com/database/121/ADMIN/dfiles.htm https://docs.oracle.com/database/121/BRADV/rcmcomre.htm

NEW QUESTION 6
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D

NEW QUESTION 7
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A. statistics recommendations
• B. SQL profile recommendations
• C. SQL statement restructure recommendations
• D. creation of materialized views to improve query performance

Answer: B

NEW QUESTION 8
Which two statements are true about Flashback Version Query? (Choose two.)

• A. The result of a query can be used as part of a DML statement.
• B. It can be used to create views.
• C. It can be used only if Flashback Data Archive is enabled for a table.
• D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.
• E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer: DE

NEW QUESTION 9
Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.
Examine the command executed to back up PDB2_1: RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?

• A. It fails because archive log files cannot be backed up using a connection to a PDB.
• B. It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.
• C. It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.
• D. It fails because the PLUGGABLE clause is missing.

Answer: B

NEW QUESTION 10
A user issues a query on the sales table and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace? (Choose two.)

• A. Drop the tenp01.dbf file, and then re-create the temp file.
• B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.
• C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.
• D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.
• E. Create a new temporary tablespace and assign it as the default to the user.

Answer: BE

NEW QUESTION 11
You want RMAN to make duplicate copies of data files when using the BACKUP command. What must you set using the RMAN CONFIGURE command to achieve this?

• A. MAXSETSIZE TO 2;
• B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
• C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
• D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Answer: D

NEW QUESTION 12
Your database is running in NOARCHIVELOG mode. One of the data files belonging to the SYSTEM tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?

• A. Shut down the instance if not already shut down, restore all data files belonging to the SYSTEM tablespace from the last backup, and restart the instance.
• B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the SYSTEM tablespace from the last backup, and restart the instance.
• C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
• D. Mount the database, restore all data files belonging to the SYSTEM tablespace from the last backup, and open the database.

Answer: C

NEW QUESTION 13
You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening PDB_1, you get an error: SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11-see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

• A. The command performs the recovery and closes the failure.
• B. The command produces an error because RMAN is not connected to the target database PDB_1.
• C. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.
• D. The command executes successfully, performs recovery, and opens PDB_1.

Answer: C

NEW QUESTION 14
Which three statements are true about the SQL*Loader utility? (Choose three.)

• A. It can be used to load data from multiple external files into multiple tables.
• B. It can be used to extract and reorganize data from external files, and then load it into a table.
• C. It can be used to load data from external files using direct path only.
• D. It can be used to create tables using data that is stored in external files.
• E. It can be used to generate unique sequential values in specified columns while loading data.

Answer: ABE

NEW QUESTION 15
The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in
which several databases are registered. Both databases are open.
You execute the RMAN commands:

Which two tasks are performed as part of the import? (Choose two.)

• A. All databases registered in the RC11 catalog are registered in the RC12C catalog.
• B. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.
• C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.
• D. Imported databases are unregistered from the RC11 catalog.
• E. Recovery catalog is resynchronized with the control files of the registered databases.

Answer: AD

NEW QUESTION 16
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

• A. Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.
• B. Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.
• C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
• D. Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
• E. Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

Answer: DE

NEW QUESTION 17
Examine the command to create a pluggable database (PDB): SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true? (Choose two.)

• A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
• B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
• C. The tablespace specifications of pdb2 are the same as pdb1.
• D. All database objects belonging to common users in PDB1 are cloned in PDB2.
• E. pdb2 is created with its own private undo and temp tablespaces.

Answer: AC

NEW QUESTION 18
You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

• A. all users except sys
• B. all users except scott
• C. all users except sys and scott
• D. all users except sys, system, and scott

Answer: B

NEW QUESTION 19
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to 12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. Identify the correct order of the required steps.

• A. 2, 1, 3, 4, 5, 6
• B. 1, 3, 4, 5, 6, 7
• C. 1, 4, 3, 5, 6, 7
• D. 2, 1, 3, 4, 5, 6, 7
• E. 1, 5, 6, 4, 3, 2

Answer: C

Explanation: This example example is a dumpfile-based full transportable export/import operation. In this case the metadata from the source database is exported to a dump file, and both the dump file and the tablespace data files are transferred to a new system. The steps would be as follows:
* (1) Set user tablespaces in the source database to READ ONLY.
* (3) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (4) From the Oracle Database 11g Release 2 (11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VERSION=12 parameter is required only when exporting from an Oracle Database 11g Release 2 database.
* (5) Copy the tablespace data files from the source system to the destination system.
* (6) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.
References:
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf, page 11

NEW QUESTION 20
Which three statements are true about common roles? (Choose three.)

• A. A common role can be granted only to a common user.
• B. Only system privileges can be granted to a common role in a container database (CDB).
• C. Object privileges can be granted to a common role in a pluggable database (PDB).
• D. A common user that is granted a common role can grant the role to other common and local users in a PDB.
• E. A common role cannot be created by a local user.

Answer: CDE

Explanation: C: Commonly granted privileges that have been made to the common role apply in the root and all PDBs to which the grantor can connect, including PDBs that may be added later on.
D: Common users can both create and grant common roles to other common and local users. E: Local users cannot create common roles.
Note: A common role is a role that is created in the root; a local role is created in a PDB.