Which statement is true?

You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAMETYPEVALUE
———————————————————————–
db_create_file_deststring db_file_name_convertstring db_filesinteger200
You verify that sufficient disk space is available and that no file currently exists in the ‘/u0l/app/oracle/
oradata/cdb1/salesdb’ location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password
ROLES=(dba)
DEFAULTTABLESPACEsales
DATAFILE’ /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf’SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/’,
‘/u01/app/oracle/oradata/cdb1/salesdb/’)
STORAGE(MAXSIZE2G)
PATK_PREFIX=’/u01/app/oracle/oradata/cdb1/SALESPDB’;
Which statement is true?

You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAMETYPEVALUE
———————————————————————–
db_create_file_deststring db_file_name_convertstring db_filesinteger200
You verify that sufficient disk space is available and that no file currently exists in the ‘/u0l/app/oracle/
oradata/cdb1/salesdb’ location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password
ROLES=(dba)
DEFAULTTABLESPACEsales
DATAFILE’ /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf’SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/’,
‘/u01/app/oracle/oradata/cdb1/salesdb/’)
STORAGE(MAXSIZE2G)
PATK_PREFIX=’/u01/app/oracle/oradata/cdb1/SALESPDB’;
Which statement is true?

A.
SALESPDB is created and is in mount state.

B.
PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.

C.
SALESPDB is created and is in read/write mode.

D.
PDB creation fails because a default temporary tablespace is not defined for SALESPDB.



Leave a Reply 0

Your email address will not be published. Required fields are marked *