Practice Test GeeksOCM - Oracle Certified Master Practice Test
← All OCM Flashcard Decks

Oracle Multitenant Architecture Flashcards

7 cards from real OCM practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Oracle Multitenant Architecture flashcards as text

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

    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.

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

    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.

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

    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.

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

    Answer: V$PDBS

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

  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)?

    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.

  6. What clause must be appended when granting a privilege to a common user so the grant applies across all containers in the CDB?

    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.

  7. A DBA wants to apply a specific initialization parameter only to PDB 'DEVPDB' without affecting other PDBs. Which command achieves this?

    Answer: ALTER SYSTEM SET parameter = value CONTAINER = DEVPDB

    ALTER SYSTEM SET = CONTAINER = sets an initialization parameter at the PDB level, overriding the CDB-level value only for that specific PDB.