Oracle Database Administration II — Question 141

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle 19c and later releases? (Choose three.)

Answer options

• A. A PDB snapshot can be a sparse copy of a source PDB.
• B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
• C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
• D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
• E. A PDB snapshot can be a full copy of a source PDB.
• F. A snapshot copy PDB can be a full copy of a source PDB.
• G. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

Correct answer: A, B, F

Explanation

The correct options A, B, and F accurately describe the characteristics of PDB snapshots in Oracle 19c. Option A correctly states that a PDB snapshot can be a sparse copy. Option B highlights the dependency of a PDB snapshot on an existing storage snapshot. Option F is also accurate as it indicates that a snapshot copy PDB can indeed be a full copy. The other options either misrepresent the functionality or are not applicable to the context.