Question 1

Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

Options :

A : 2,4,5,6

B : 1,2,3,4,5,6

C : 1,2,4,5

D : 2,4,5

E : 1,3,4,5

Answer: D

Question 2

Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

Options :

A : The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

B : The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C : The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog

D : The base catalog must be enabled for Virtual Private Catalog use.

E : The target PDB must be registered in a Virtual Private Catalog.

F : The target PDB must be registered in a base catalog.

Answer: A,C,D

Question 3

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

Options :

A : Create the PDB1 application PDB and synchronize it with poB$SEED.

B : Create the PDB1 application PDB and synchronize it with HR_ROOT.

C : Create the PDB1 application PDB and install HR_APP in it.

D : Create an application seed, and install HR_APP in it.

E : Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Answer: A,B

Question 4

A database is configured in ARCHIVE LOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)

Options :

A : after losing a SYSAUX tablespace data file

B : after losing all members of an INACTIVE online redo log group

C : after losing all members of the CURRENT online redo log group

D : after losing all copies of the control file

E : after losing an UNDO tablespace that is in use

Answer: C,D

Question 5

Choose two. Which two are true about a Recovery Manager (RMAN) duplication without a TARGET connection?

Options :

A : The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

B : RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

C : The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

D : The UNDO TABLESPACE clause is never required.

E : RMAN 'pushes' the backups of the database to be duplicated over the network to the auxiliary instance.

Answer: A,B