Oracle Database 12c: Advanced Administration — Question 37

You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?

Answer options

• A. The PDB is closed and left in the unmount state.
• B. The PDB is placed and left in the mount state.
• C. The command executes only if the common user is granted the set container privilege for the PDB.
• D. The command results in an error because the PDB can be shut down only by a local user.

Correct answer: A

Explanation

The correct answer is A because issuing the shutdown immediate command while connected as a common user with sysdba privileges closes the PDB and leaves it in an unmount state. Options B and C are incorrect as they misrepresent the state of the PDB after the command, and option D is wrong because the command can be executed by a common user with the appropriate privileges.