Oracle 1Z0-063 dumps - 100% Pass Guarantee!

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

Which three statements are true about Flashback Data Archive? (Choose three.)

A. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.

D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

You plan to create a new PDB by copying PDB$SEED.

Which two requirements ensure a successful creation? (Choose two.)

A. The CDB must have PDB_FILE_NAME_CONVERT configured before executing the command.

B. A default service for the new PDB name must already exist.

C. A PDB local administrative user must be granted the DBA role when creating the PDB.

D. A PDB local administrative user must be specified when creating the PDB.

E. The CDB, which will contain the PDB, must be in READ WRITE mode.

F. The CDB must use Oracle Managed Files.

You want to create a guaranteed restore point for one of your databases by executing the command:

SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

Which two are required for the successful execution? (Choose two.)

A. The database must be in ARCHIVELOG mode.

B. Flashback Database must be enabled.

C. The Fast Recovery Area must be configured.

D. The database must be mounted.

E. Undo retention guarantee must be enabled.

F. The database must be opened.

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

A. tracking the most recent read time for a table segment in a user tablespace

B. tracking the most recent write time for a table segment in a user tablespace

C. tracking insert time by row for table rows

D. tracking the most recent write time for each block in a table segment

E. tracking the most recent read time for a table segment in the sysaux tablespace

F. tracking the most recent write time for a table segment in the sysaux tablespace