1Z0-067 · Question #53
You are administering a multitenant container database (CDB) cdb1. Examine the command and its output: SQL>show parameterfile NAMETYPEVALUE…
The correct answer is A. SALESPDB is created and is in mount state. We need seed tablespace to create new plugable db. /u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/orcl/pdbseed/system01.dbf By default. Seed has two tbs.
Question
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?
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
(27 responses)- A74% (20)
- B7% (2)
- C4% (1)
- D15% (4)
Explanation
We need seed tablespace to create new plugable db. /u01/app/oracle/oradata/orcl/pdbseed/sysaux01.dbf /u01/app/oracle/oradata/orcl/pdbseed/system01.dbf By default. Seed has two tbs.
Topics
Community Discussion
No community discussion yet for this question.