Oracle Database 12c: Advanced Administration — Question 63

Which two statements are true about dropping a pluggable database (PDB)?

Answer options

• A. A PDB must be in mount state or it must be unplugged.
• B. The data files associated with a PDB are automatically removed from disk.
• C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
• D. A PDB must be in closed state.
• E. The backups associated with a PDB are removed.
• F. A PDB must have been opened at least once after creation.

Correct answer: A, D

Explanation

The correct answers are A and D because a PDB must be in either mount state or unplugged to be dropped, and it must be in a closed state. Options B and E are incorrect as the data files and backups are not automatically removed when a PDB is dropped; they need to be manually managed. Option C is incorrect because once a PDB is dropped and unplugged, it cannot be plugged back into any CDB. Option F is also incorrect as there is no requirement for a PDB to be opened after creation to be dropped.