1z0-083: Oracle Database Administration II Rman Practice Questions

A database is configured in ARCHIVELOG mode. Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred. In which two scenarios is complete recovery possible? (Choose two.)

Select 2 answers.

• AA. when any archived log from, before, or after the most recent backup is corrupt.
• BB. after losing all copies of the control file
• CC. after losing an archived log from after the most recent backup
• DD. after losing an archived log from before the most recent backup
• EE. after losing the SYSTEM tablespace

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

Select 3 answers.

• AA. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• BB. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• CC. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• DD. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
• EE. It is always possible for RMAN to connect to a pluggable database as a target.
• FF. A Virtual Private Catalog used to register a container database can be created in a non-container database.

Examine these queries and their output: An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 toRestore Point R1. How do you achieve this?

• AA. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to PDB1.
• BB. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to PDB1.
• CC. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to CDB$ROOT.
• DD. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to CDB$ROOT.
• EE. This cannot be done due to the lack of aclean restore point.

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

Select 2 answers.

• AA. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
• BB. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
• CC. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
• DD. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
• EE. CDB$ROOT and PDB$SEED are automatically duplicated.