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

READ WRITE

Answer

READ ONLY

Answer

RESTRICTED

Question 2

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

Accepted Answer

ALTER PLUGGABLE DATABASE ALL OPEN

Answer

ALTER SYSTEM OPEN ALL PDBS

Answer

ALTER DATABASE OPEN ALL CONTAINERS

Answer

STARTUP ALL PDBS

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 PERSISTENT OPEN

Answer

ALTER DATABASE SAVE PDB STATE

Answer

ALTER PLUGGABLE DATABASE SET AUTOSTART

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

CDB_DATABASES

Answer

DBA_PDBS

Answer

GV$CONTAINERS

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

ENABLE_CLONING = TRUE

Answer

ENABLE_GOLDENGATE_REPLICATION = TRUE

Answer

db_recovery_file_dest must be configured

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?

Accepted Answer

WITH CONTAINER = ALL

Answer

FOR ALL CONTAINERS

Answer

GLOBAL = TRUE

Answer

CDB_WIDE = TRUE

Question 7

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

Accepted Answer

ALTER SYSTEM SET parameter = value CONTAINER = DEVPDB

Answer

ALTER SESSION SET parameter = value FOR PDB DEVPDB

Answer

ALTER PLUGGABLE DATABASE DEVPDB SET parameter = value

Answer

ALTER SYSTEM SET parameter = value SCOPE=SPFILE