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?
A.
All redo log files are opened.
B.
The root, the seed, and all the PDBs are opened in read-write mode.
C.
All the PDBs are opened in read-write mode.
D.
All the PDBs are in closed state.
E.
Only the root database is opened in read-write mode.
A & E are the correct answers.
A and E
A & C are the correct answers
If neither OPEN READ WRITE nor OPEN READ ONLY is specified and RESTRICT is specified, then the PDB is opened in read-only mode when the CDB to which it belongs is a physical standby database. Otherwise, the PDB is opened in read/write mode.
http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14097
Pluggable Database (PDB) Automatic Startup
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.
Maybe it is A & E…
Can anyone please advise??
Correct. It’s A and E
Thanks Vonpire!
AE
AE
Good to hear, all agree to one answer, A & E.
Startup in Oracle 12c with two PDBs and no triggers (for pdb’s automatic open):
SQL> startup
ORACLE instance started.
Total System Global Area 835104768 bytes
Fixed Size 2293880 bytes
Variable Size 322965384 bytes
Database Buffers 507510784 bytes
Redo Buffers 2334720 bytes
Database mounted.
Database opened.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———- —————————— ———- ———-
2 PDB$SEED READ ONLY NO
3 PDB01 MOUNTED
4 PDB02 MOUNTED
So:
A. ==> CORRECT – Is the Oracle normal operation.
All redo log files are opened.
B. ==> WRONG – All PDBs are mounted, not opened.
The root, the seed, and all the PDBs are opened in read-write mode.
C. ==> WRONG – Idem.
All the PDBs are opened in read-write mode.
D. ==> WRONG – All PDBs are mounted.
All the PDBs are in closed state.
E. ==> Better option; root database, but also pdb$seed are opened in read-write mode.
Only the root database is opened in read-write mode.
So, A and E.
AE