Free Oracle 1z0-063 Exam Dumps Questions & Answers

Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command? (Choose two.)

• A.The root and the seed database in the container database (CDB) are also duplicated.
• B.The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.
• C.A backup of pdb1 and pdb5 must exist before executing the command.
• D.An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
• E.The SPFILE is copied along with the data files of the pluggable databases (PDBs).

You execute the command to recover your database:

Which statement is true?

• A.It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
• B.It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".
• C.It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task.
• D.It restores all data files from the specified time, and then applies the redo logs.

Identify two scenarios in which the RMAN CROSSCHECK command can be used. (Choose two.)

• A.when listing backups that are required for recovery operations
• B.when checking for backups that are not required as per the retention policy
• C.when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible
• D.when synchronizing backups, which were not performed by using RMAN, with the RMAN repository
• E.when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

• A.to automatically delete obsolete backups after a specified period of time
• B.to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
• C.to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog
• D.to store backup information of multiple databases in one place
• E.to restrict the amount of space that is used by backups

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

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