Oracle
1Z0-063 · Question #146
You are administering a multitenant container database (CDB) cdb1. Examine the command and itsoutput: SQL>show parameterfile NAMETYPEVALUE db_create_file_deststring db_file_name_convertstring…
The correct answer is B. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB. See the full explanation below for the reasoning.
Question
You are administering a multitenant container database (CDB) cdb1. Examine the command and itsoutput: 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?Options
- ASALESPDB is created and is in mount state.
- BPDB creation fails because the D3_file_name_convert parameter is not set in the CDB.
- CSALESPDB is created and is in read/write mode.
- DPDB creation fails because a default temporary tablespace is not defined for SALESPDB.
How the community answered
(32 responses)- A16% (5)
- B75% (24)
- C3% (1)
- D6% (2)
Community Discussion
No community discussion yet for this question.