You run a script that completes successfully using SQL*Plus that performs these actions:
1. Creates a multitenant container database (CDB)
2. Plugs in three pluggable databases (PDBs)
3. Shuts down the CDB instance
4. Starts up the CDB instance using STARTUP OPEN READ WRITE
Which two statements are true about the outcome after running the script?
A.
The seed will be in mount state.
B.
The seed will be opened read-only.
C.
The seed will be opened read/write.
D.
The other PDBs will be in mount state.
E.
The other PDBs will be opened read-only.
F.
The PDBs will be opened read/write.
Explanation:
B: The seed is always read-only.
D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER
PLUGGABLE DATABASE command.
B and D
B. The seed will be opened read-only.
D. The other PDBs will be in mount state
BD
BD – OK
BD
BD
The seed will always be opened in “READ ONLY” mode. When you open the CDB in READ WRITE mode, all the PDBs within that CDB, will always be in a ‘MOUNTED’state. You have to either manually open the individual PDBs, or create a trigger to open the PDBs, whenever a CDB is opened.
Hence the answers are: B, D
BD
B,D are correct
BD are correct.