Upgrade Oracle DBA 11g to Oracle Database 12c — Question 29

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.
• B. The PDB is placed in 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 a common user with sysdba privileges can issue the shutdown immediate command to close the PDB. Option B is incorrect as the PDB does not enter mount state when shut down immediately, and option C is not applicable since the command can be executed without needing the set container privilege. Option D is also wrong because a common user with sysdba can indeed shut down a PDB.