Oracle Exam 1Z0-063 Topic 3 Question 44 Discussion

Actual exam question for Oracle's 1Z0-063 exam

Question #: 44
Topic #: 3

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?

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 MOUNT state.

ECDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode.

Show Suggested Answer

Suggested Answer: D

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

by Arlette at May 03, 2022, 01:50 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-063 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!