Oracle Database Administration II — Question 44

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

Answer options

• A. A PDB snapshot is always a full copy of the source PDB.
• B. A PDB snapshot is always a sparse copy of the source PDB.
• C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• G. A snapshot copy PDB can be created from a stand-alone clone PDB.

Correct answer: C, G

Explanation

Option C is correct because a snapshot copy PDB indeed relies on a storage snapshot that is restricted to specific file systems. Option G is also correct as it states that a snapshot copy PDB can be made from a stand-alone clone PDB. The other options are incorrect because they either misrepresent the nature of snapshots or their storage requirements.