Oracle Database 12c: Installation and Administration — Question 199

Which two statements are true concerning dropping a pluggable database (PDB)? (Choose two.)

Answer options

• A. The PDB must be open in read-only mode.
• B. The PDB must be in mount state.
• C. The PDB must be unplugged.
• D. The PDB data files are always removed from disk.
• E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Correct answer: B, C

Explanation

The correct answers are B and C because a PDB must be in the mount state and unplugged before it can be dropped. Options A and D are incorrect since a PDB does not need to be in read-only mode to be dropped, and the data files might not always be removed from disk depending on the drop method. Option E is also incorrect because there are ways to replug a PDB under certain conditions.