Question 1

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

Options :

A : A PDB snapshot depends on an existing storage snapshot of the source PDB.

B : APDB snapshot can be a full copy of a source PDB.

C : A PDB snapshot can be a sparse copy of a source PDB

D : A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

E : A snapshot copy PDB can be a full copy of a source PDB

Answer: B,C

Question 2

Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

Options :

A : A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database-s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

B : Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.

C : Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.

D : A target database-s persistent RMAN configuration settings are always stored in the target-s control file

Answer: C,D

Question 3

Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

Options :

A : APP1_USER1can be created in PDB1.

B : APP1_USER1can be created in CDB1.

C : APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

D : C##_APP_USER1 can be created in CDB1.

E : P1_USER1can be created in CDB1.

F : C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.

Answer: C,D

Question 4

Choose three. Which three activities are possible for PDBs?

Options :

A : converting an application seed to an application PDB

B : converting a regular PDB to an application PDB

C : converting an application PDB to an application root

D : copying an application container into another application container in the same CDB

E : copying an application container into another application container in a different CDB

F : converting an application PDB to an application seed G) converting an application PDB to a regular PDB

Answer: B,D,F

Question 5

Choose three. Which three are true about block media recovery?

Options :

A : To use it, Flashback Database must be enabled.

B : A block being recovered is not accessible.

C : It cannot repair logical corruption.

D : It can be performed on noncorrupt blocks.

E : The target database for which one or more blocks are to be recovered must be in the OPEN state.

F : The data file containing the block being recovered remains online.

Answer: B,C,F

Free 1Z0-083 Mock Exam – Practice Online Confidently

Buying Options: