1Z0-067 · Question #135
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 the CDB1. 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. undotbs1is used as the undo tablespace for both the root and seed databases. The seed actually doesn't use anything since it's read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.
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 the CDB1. 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.
- Eundotbs1is 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
(54 responses)- A81% (44)
- C2% (1)
- D11% (6)
- F6% (3)
Explanation
The seed actually doesn't use anything since it's read-only, but any PDB created from the seed will use the undotbs1 undo tablespace. Each PDB can have its own default tablespace, but cannot change the undo tablespace.
Topics
Community Discussion
No community discussion yet for this question.