OCP CBT Question 491

Please solve the following question.

You want to completely remove a pluggable database named `OLD_PDB` from `CDB01`, including all its associated data files. Examine the following SQL command: ```sql DROP PLUGGABLE DATABASE old_pdb; ``` What is the most accurate description of the outcome of this command?

OLD_PDB is currently in the MOUNTED state.

The command will fail because OLD_PDB must be explicitly closed before dropping.

The command will succeed, dropping OLD_PDB, but its data files will remain on the file system.

The command will succeed, dropping OLD_PDB and automatically deleting its data files from the file system.

The command will fail because OLD_PDB must be unplugged before it can be dropped.