Upgrade to Oracle Database 12c — Question 18

Which statement is true concerning dropping a pluggable database (PDB)?

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

Explanation

The correct answer is B because a pluggable database (PDB) must be in the mount state to be dropped, allowing for control over the dropping process. Option A is incorrect as the PDB does not need to be in read-only mode, option C is incorrect because it does not need to be unplugged first, option D is wrong since the data files may not always be removed immediately, and option E is false as a dropped PDB can sometimes be plugged back in under certain circumstances.