What is the effect of specifying the “ENABLE PLUGGABLE DATABASE” clause in a
“CREATE DATABASE” statement?
A.
It will create a CDB with root opened and seed mounted.
B.
It will create a CDB that must be plugged into an existing CDB.
C.
It will create a CDB with root and seed opened and one PDB mounted.
D.
It will create a multitenant container database (CDB) with only the root opened.
E.
It will create a CDB with root opened and seed read only.
B
Right Answer is E
E
B is incorrect, you can never plug a CDB into another CDB
E is correct
https://docs.oracle.com/database/121/CNCPT/cdbovrvw.htm#CNCPT89243
“The CREATE DATABASE … ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.
Along with the root container (CDB$ROOT), Oracle Database automatically creates a seed PDB (PDB$SEED). “