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.
BC
BD
BD
SQL> STARTUP OPEN READ WRITE;
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2924928 bytes
Variable Size 520097408 bytes
Database Buffers 1073741824 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
SQL> select NAME,OPEN_MODE from v$pdbs;
NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDB1 MOUNTED
PDB2 MOUNTED
PDB3 MOUNTED
NEW_PDB MOUNTED
Its B and D
SQL> select NAME,OPEN_MODE from v$pdbs;
NAME OPEN_MODE
—————————— ———-
PDB$SEED READ ONLY
PDB1 MOUNTED
PDB2 MOUNTED
PDB3 MOUNTED
right Mr. nax
Answer is B,D
BD