Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST =’/u01/app/oracle/oradata/’
You execute the following command to create theCDB1. container database (CDB):
SQL>CREATEDATABASECDB1
DEFAULTTABLESPACE users
DEFAULTTEMPORARY TABLESPACEtemp
UNDO TABLESPACEundotbsl
ENABLEPLUGGA3LEDATABASE
SEED
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED
SYSAUXDATAFILESSIZE100M;
Which three statements are true?
A.
It creates a multitenant container database with a root and a seed pluggable database (PDB) that are
opened in read-write and read-only modes, respectively.
B.
The files created for both the root and seed databases use Oracle Managed Files (OMF).
C.
It creates a multitenant container database with the root and seed databases opened and one PDB
mounted.
D.
It sets the users tablespace as the default for both the root and seed databases.
E.
undotbs1 is used as the undo tablespace for both the root and seed databases.
F.
It creates a multitenant container database with the root database opened and the seed database mounted.
ans a,b,e
ANS A,B,E