Oracle Database 12c Advance Adminstration1z0-063 Test 1

Question : 14 of 40

Marks: +1, -0

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 CDB1 container database (CDB):

SQL>CREATE DATABASE CDB1 
 DEFAULT TABLESPACE users 
 DEFAULT TEMPORARY TABLESPACE 
 temp 
  UNDO TABLESPACE 
 Undotbsl ENABLE 
 PLUGGABLE DATABASE SEED 
 SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE 
 UNLIMITED SYSAUX DATAFILES SIZE 100M;

Which three statements are true? (Choose three.)

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.
The files created for both the root and seed databases use Oracle Managed Files (OMF).
It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
It sets the users tablespace as the default for both the root and seed databases.
undotbs1 is used as the undo tablespace for both the root and seed databases.
It creates a multitenant container database with the root database opened and the seed database mounted

Validate

Go to Question:

Prev Question

Next Question