Exam 1z0-063 topic 1 question 24 discussion

Actual exam question from Oracle's 1z0-063

Question #: 24
Topic #: 1

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.