Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command: SQL>STARTUP Which two statements…

The correct answer is A. All redo log files are opened. E. Only the root database is opened in read-write mode. The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn't be implementing a trigger in the manner discussed in this section. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default…

New Features for Database Infrastructure and Architecture

Question

Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:

SQL>STARTUP Which two statements are true about the successful execution of the command?

Options

AAll redo log files are opened.
BThe root, the seed, and all the PDBs are opened in read-write mode.
CAll the PDBs are opened in read-write mode.
DAll the PDBs are in closed state.
EOnly the root database is opened in read-write mode.

How the community answered

(31 responses)

A
74% (23)
B
16% (5)
C
3% (1)
D
6% (2)

Explanation

The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn't be implementing a trigger in the manner discussed in this section. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.

Topics

#CDB startup#PDB state#STARTUP command#multitenant

Community Discussion

No community discussion yet for this question.

Full 1Z0-067 Practice