Oracle
1Z0-063 · Question #33
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)…
The correct answer is A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that B. The files created for both the root and seed databases use Oracle Managed Files (OMF). E. undotbs1 is used as the undo tablespace for both the root and seed databases. See the full explanation below for the reasoning.
Question
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?
Options
- AIt creates a multitenant container database with a root and a seed pluggable database (PDB) that
- BThe files created for both the root and seed databases use Oracle Managed Files (OMF).
- CIt creates a multitenant container database with the root and seed databases opened and one
- DIt sets the users tablespace as the default for both the root and seed databases.
- Eundotbs1 is used as the undo tablespace for both the root and seed databases.
- FIt creates a multitenant container database with the root database opened and the seed database
How the community answered
(26 responses)- A73% (19)
- C8% (2)
- D4% (1)
- F15% (4)
Community Discussion
No community discussion yet for this question.