Exam 1z0-063 topic 1 question 94 discussion

Actual exam question from Oracle's 1z0-063

Question #: 94
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: B 🗳️

by sherifelia at Feb. 1, 2020, 2:01 p.m.

Comments

Submit Cancel

Sugar

4 years, 10 months ago

Should be A FILE_NAME_CONVERT=(/u01/app/oracle/oradata/cdb1/pdbseed/', '/u01/app/oracle/oradata/cdb1/salesdb/') this is correct

upvoted 1 times

...

rcgenilo27

5 years ago

A is the correct answer

upvoted 1 times

...

sherifelia

5 years, 2 months ago

Answer A

upvoted 3 times

...

Exam 1z0-063 All Questions

View all questions & answers for the 1z0-063 exam

Exam 1z0-063 topic 1 question 94 discussion

Comments

Sugar

rcgenilo27

sherifelia

SY0-701