Question 1

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 2

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 3

choose one You take regular backups of one of your production databases by using RMAN with a recovery catalog. You have added two new tablespaces to this database which must be included in future backups. Which process occurs which allows the new backups to contain the new datafiles?

Options :

A : The target database control file is synchronized from the recovery catalog with a partial resync at the next backup.

B : The recovery catalog is synchronized from the target database control file with a full resync at the next backup.

C : The target database control file is synchronized from the recovery catalog with a full resync at the next backup.

D : The recovery catalog is synchronized from the target database control file with a partial resync at the next backup.

Answer: B

Question 4

Choose three. Which three are true about a whole database backup?

Options :

A : It can be created only by using RMAN.

B : It always includes all data files, the current control file, the server parameter file, and archived redo logs.

C : It can be consistent.

D : Â It is the only possible backup type for a database in NOARCHIVELOG mode.

E : It can consist of either backup sets or image copies. F) It can be inconsistent.

Answer: C,D,E

Question 5

Which two are true about Oracle Flashback features? (Choose two.)

Options :

A : FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

B : FLASHBACK VERSION QUERY can retrieve REDO records from ONLINE and ARCHIVE D REDO LOG files.

C : FLASHBACK TABLE can undrop a column.

D : FLASHBACK DROP can undrop an index when undropping a table.

E : After a database is restored from flashback logs using the FLASHBACK DATABASE command, it is sometimes rolled forward using redo logs.

Answer: A,D

Confidently Practice Online with Free 1Z0-083 Exam Cram

Buying Options: