ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

89 / 155

Question 89:

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 .dbfSIZE 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? 

Answer options:

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.