Examine the initialization parameter that is set in the PFILE:DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'You execute

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Examine the initialization parameter that is set in the PFILE:DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'You execute

Post by answerhappygod »

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 -tempUNDO TABLESPACE -Undotbsl ENABLE -PLUGGABLE DATABASE SEED -SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZEUNLIMITED SYSAUX DATAFILES SIZE 100M;Which three statements are true? (Choose three.)

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply