What is the prerequisite for performing an active database duplication on a source database that is in a mounted state?
That the source database was shut down cleanly
When performing an active database duplication, for what purpose would you use the DB_FILE_NAME_CONVERT clause of the RMAN DUPLICATE command?
To specify how to convert source datafile names to new datafile names
Which clause of the RMAN DUPLICATE command should you specify to indicate that the duplication should be performed online?
The FROM ACTIVE DATABASE clause
Which databases are visible to a virtual catalog owner?
Only the databases for which the owner has been granted access
Which RMAN command should you issue to indicate that all archived logs that have been backed up more than five times should be eligible for deletion?
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 5 TIMES TO devicetype;
When performing an RMAN backup, does the configured retention policy or the KEEP clause of the BACKUP command take precedence?
The KEEP clause of the BACKUP command
If autobackup is disabled, what will be backed up when you specify the KEEP option when performing an RMAN backup?
The control file, the current SPFILE file, datafiles, and archived redo logs
When multiple archive destinations are used, which feature allows you to perform an archived redo log backup, even if one of the archived redo log files is missing or corrupt?
The archived redo log failover feature
Which privilege should be granted to a user to indicate that the user is the owner of a virtual private catalog?
The RECOVERY_CATALOG_OWNER privilege
When importing metadata from a recovery catalog, to which recovery catalog must you be connected?
The destination recovery catalog
Which action must you take to create a virtual private catalog for an Oracle 10g database?
From SQL*Plus, execute the base_catalog_owner.DBMS_RCVCAT.CREATE_VIRTUAL_CATALOG procedure
Which statement should you use to grant access to the PROD2 and PROD3 registered databases to the virtual private catalog owner VPOWNER1?
The GRANT CATALOG FOR DATABASE prod2, prod3 TO vpowner1; statement
To perform most RMAN functions, which privilege should the owner of a virtual catalog have on the target database?
The SYSDBA or SYSOPER privilege
What metadata is imported with the IMPORT CATALOG command if you do not specify either a DBID or DB_NAME?
All metadata for all registered databases in the catalog
When performing an active database duplication, which clause of the RMAN DUPLICATE command should you specify to indicate that the duplicate database filenames should be the same as the source database filenames?
The NOFILENAMECHECK clause
What is the result on registered databases if you issue an IMPORT CATALOG command and do not specify the NO UNREGISTER clause?
The databases registered in the source recovery catalog are registered in the destination recovery catalog and unregistered in the source recovery catalog.
Which RMAN command should you use to update image copies with all changes up to a specific incremental backup?
The RECOVER COPY OF DATAFILE command
Which clause of the BACKUP command provided by RMAN will create a compressed backup?
The AS COMPRESSED clause
If you are using RMAN to back up files over a network and CPU performance is of lesser importance, which clause should you use with the RMAN BACKUP command to reduce the size of the backups and minimize network traffic?
The AS COMPRESSED clause
What is the result if you issue an IMPORT CATALOG command and global stored scripts in the source and destination catalogs have identical names?
The global scripts in the source catalog are renamed.
Which clause should you specify when performing an RMAN backup to indicate that the backup be kept until it is explicitly deleted by the DBA?
The KEEP FOREVER clause
What happens if you specify a section size in your RMAN BACKUP command that is larger than the size of the entire file?
The backup will not be performed as a multisection backup.
Which RMAN command can you use to import the metadata from another recovery catalog?
The IMPORT CATALOG command
When performing active database duplication, what must be true regarding the password file of the auxiliary instance?
It must exist and have the same SYSDBA password as the source database.
Which clause should you use with the RMAN BACKUP command to back up a very large datafile in sections rather than at the file level?
The SECTION SIZE clause
Which clause of the RMAN BACKUP command can you specify with the KEEP clause to create a restore point, identifying the SCN at which the database backup is consistent?
The RESTORE POINT clause
If you are using RMAN to back up files to a CD, which clause might you use with the RMAN BACKUP command to minimize the cost of your backup media?
The AS COMPRESSED clause
When performing an active database duplication on an open source database, the source database must be in which archive log mode?
Which type of backup should you perform if you are backing up to disk and have limited space on the backup destination?
Which RMAN command can you use to create a virtual private catalog for an Oracle 11g database?
The CREATE VIRTUAL CATALOG command
When performing an active database duplication, which clause of the RMAN DUPLICATE command should you specify to indicate that the password file for the auxiliary instance should be overwritten with the source database password file?
The PASSWORD FILE clause
To what does the term intrafile parallel backup refer?
A multisection backup performed in parallel
As the base catalog owner, which RMAN command should you issue to allow the virtual catalog owner VOWNER1 to register a target database in the virtual private catalog?
The GRANT REGISTER DATABASE TO vowner1; command
Which three actions must you take to perform a multisection backup in parallel?
Configure the SBT channels
Set the parallelism for the SBT device
Issue the BACKUP command with the SECTION SIZE clause