nerdexam
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)
  • A
    16% (5)
  • B
    75% (24)
  • C
    3% (1)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice