You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB. SQL> STARTUP…

Question

Options

• ACDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.
• BCDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.
• CCDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.
• DCDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in
• ECDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

• A
  5% (3)
• B
  9% (6)
• C
  2% (1)
• D
  83% (53)
• E
  2% (1)

Explanation

If neither READ WRITE nor READ ONLY is specified, a PDB will be opened in READ ONLY if a CDB to which it belongs is used as a physical standby database, otherwise the PDB will be opened READ WRITE. Prerequisites for a PDB STARTUP When the current container is a pluggable database (PDB), the STARTUP command can only be * The PDB is in MOUNTED mode, excluding the use of the FORCE option. * The PDB must be in READ ONLY or READ WRITE mode to be in mounted mode.

No community discussion yet for this question.