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
Which statement is true?
A.
CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode.
B.
CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode.
C.
CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode.
D.
CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state.
E.
CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.
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 used if:
* 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.
Etc.
References: https://docs.oracle.com/database/121/SQPUG/ch_twelve045.htm
D