Oracle Database 12c: Advanced Administration — Question 152

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.

Correct answer: A, B, E

Explanation

The correct statement A indicates that a multitenant architecture is created where the root database is in read-write mode and the seed database in read-only mode. Option B is also correct as the initialization parameter allows for the use of Oracle Managed Files, which automatically manages the file locations. Option E is valid as well since the command specifies undotbs1 as the undo tablespace for both databases. Options C, D, and F are inaccurate in their description of database states and configurations.