Oracle Database 12c: Installation and Administration — Question 200

You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

Answer options

• A. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
• B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• D. The statement results in an error because there are open PDBs.

Correct answer: B

Explanation

The correct answer is B because the SHUTDOWN TRANSACTIONAL statement only waits for transactions in the CDB to complete before proceeding with the shutdown. Options A and C incorrectly imply that transactions in the PDBs must also be completed, while option D is incorrect as the statement can still execute despite open PDBs.