Oracle Database Administration II — Question 162

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

Answer options

• A. A snapshot copy PDB can be a full copy of a source PDB.
• B. A PDB snapshot can be a sparse copy of a source PDB.
• C. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
• D. A PDB snapshot depends on an existing storage snapshot of the source PDB.
• E. A PDB snapshot can be a full copy of a source PDB.

Correct answer: B, E

Explanation

Answer B is correct because a PDB snapshot can indeed be created as a sparse copy, which means it only contains the necessary data rather than duplicating everything. Answer E is also correct as a PDB snapshot can be a full copy of the source PDB. The other options are incorrect based on the principles of how snapshots function in Oracle databases.