OCM Oracle Multitenant Architecture 2 — Questions and Answers
Question 1: What is the default open mode of a PDB immediately after it is created using CREATE PLUGGABLE DATABASE from PDB$SEED?
- READ WRITE
- MOUNTED (Correct answer)
- READ ONLY
- RESTRICTED
Correct answer: MOUNTED
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?
- ALTER SYSTEM OPEN ALL PDBS
- ALTER DATABASE OPEN ALL CONTAINERS
- ALTER PLUGGABLE DATABASE ALL OPEN (Correct answer)
- STARTUP ALL PDBS
Correct answer: ALTER PLUGGABLE DATABASE ALL OPEN
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?
- ALTER PLUGGABLE DATABASE SAVE STATE (Correct answer)
- ALTER PLUGGABLE DATABASE PERSISTENT OPEN
- ALTER DATABASE SAVE PDB STATE
- ALTER PLUGGABLE DATABASE SET AUTOSTART
Correct answer: ALTER PLUGGABLE DATABASE SAVE STATE
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?
- CDB_DATABASES
- DBA_PDBS
- V$PDBS (Correct answer)
- GV$CONTAINERS
Correct answer: V$PDBS
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)?
- ENABLE_CLONING = TRUE
- LOCAL_UNDO = TRUE (Correct answer)
- ENABLE_GOLDENGATE_REPLICATION = TRUE
- db_recovery_file_dest must be configured
Correct answer: LOCAL_UNDO = TRUE
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.
Question 6: What clause must be appended when granting a privilege to a common user so the grant applies across all containers in the CDB?
- FOR ALL CONTAINERS
- WITH CONTAINER = ALL (Correct answer)
- GLOBAL = TRUE
- CDB_WIDE = TRUE
Correct answer: WITH CONTAINER = ALL
Appending WITH CONTAINER = ALL to a GRANT statement extends the privilege to the common user in CDB$ROOT and all existing and future PDBs.
Question 7: A DBA wants to apply a specific initialization parameter only to PDB 'DEVPDB' without affecting other PDBs. Which command achieves this?
- ALTER SYSTEM SET parameter = value CONTAINER = DEVPDB (Correct answer)
- ALTER SESSION SET parameter = value FOR PDB DEVPDB
- ALTER PLUGGABLE DATABASE DEVPDB SET parameter = value
- ALTER SYSTEM SET parameter = value SCOPE=SPFILE
Correct answer: ALTER SYSTEM SET parameter = value CONTAINER = DEVPDB
ALTER SYSTEM SET <parameter> = <value> CONTAINER = <PDB_name> sets an initialization parameter at the PDB level, overriding the CDB-level value only for that specific PDB.
OCM Oracle Multitenant Architecture 2
What is the default open mode of a PDB immediately after it is created using CREATE PLUGGABLE DATABASE from PDB$SEED?