ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

24 / 155

Question 24:

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? 

Answer options:

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.