OCM Oracle Multitenant Architecture 2

Question 1

What is the default open mode of a PDB immediately after it is created using CREATE PLUGGABLE DATABASE from PDB$SEED?

Accepted Answer

MOUNTED

Answer

A newly created PDB starts in MOUNTED mode and must be explicitly opened using ALTER PLUGGABLE DATABASE OPEN before users can connect to it.

Question 2

Which single SQL statement opens all PDBs in a CDB simultaneously?

Accepted Answer

ALTER PLUGGABLE DATABASE ALL OPEN

Answer

ALTER PLUGGABLE DATABASE ALL OPEN is the CDB-level command that opens every PDB in the CDB in a single statement.

Question 3

Which command persists the current open mode of PDBs so they automatically return to that state after the CDB restarts?

Accepted Answer

ALTER PLUGGABLE DATABASE SAVE STATE

Answer

ALTER PLUGGABLE DATABASE SAVE STATE records each PDB's current open mode so that the CDB automatically restores that state when it is restarted.

Question 4

Which dynamic performance view displays the real-time open mode (MOUNTED, READ WRITE, READ ONLY) of each PDB in a CDB?

Accepted Answer

V$PDBS

Answer

V$PDBS is the dynamic performance view that shows current status information for all PDBs, including their real-time open mode.

Question 5

What prerequisite must be met at the CDB level to perform a Hot Clone (clone a PDB while it remains open in READ WRITE mode)?

Accepted Answer

LOCAL_UNDO = TRUE

Answer

Hot Cloning requires LOCAL_UNDO = TRUE so the source PDB has its own undo tablespace, enabling redo synchronization during the clone operation while the PDB stays open.

OCM - Oracle Certified Master Practice Test

OCM - Oracle Certified Master Practice Test

OCM Oracle Multitenant Architecture 2