Oracle Database 12c: Advanced Administration — Question 145

Examine this command:

SQL> CREATE DATABASE cdb1 -

DEFAULT TABLESPACE users -
DEFAULT TEMPORARY TABLESPACE temp

UNDO TABLESPACE undotbs1 -

ENABLE PLUGGABLE DATABASE -

SEED -
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created?

Answer options

• A. The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.
• B. The PDB_FILE_NAME_CONVERT parameter must be configured.
• C. The FILE_NAME_CONVERT clause must be added to the command.
• D. The USER_DATA TABLESPACE clause must be added to the command.
• E. The DB_CREATE_FILE_DEST parameter must be configured.

Correct answer: A, C

Explanation

The correct answer is A and C because setting ENABLE_PLUGGABLE_DATABASE to TRUE is essential for creating a container database, and the FILE_NAME_CONVERT clause is necessary for naming conventions of pluggable databases. Options B, D, and E are not required for the creation of a CDB, making them incorrect.