Examine the command for creating pluggable database PDB2 in container database CDB2. Select three options, any one of which is required for it to execute successfully. (Choose three.)

The correct answer is B. Add only the CREATE_FILE_DEST clause to the statement. C. Set only the PDB_FILE_NAME_CONVERT parameter. E. Enable only OMF. You can specify FILE_NAME_CONVERT = NONE, which is the same as omitting this clause. If you omit this clause, then the database first attempts to use Oracle Managed Files to generate file names. If you are not using Oracle Managed Files, then the database uses the…

Manage Multitenant Container Databases

Question

Options

AAdd the FILE_NAME_CONVERT clause to the statement and set the
BAdd only the CREATE_FILE_DEST clause to the statement.
CSet only the PDB_FILE_NAME_CONVERT parameter.
DSet the PDB_FILE_NAME_CONVERT parameter and enable OMF.
EEnable only OMF.
FAdd the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files

How the community answered

(39 responses)

A
5% (2)
B
85% (33)
D
8% (3)
F
3% (1)

Explanation

You can specify FILE_NAME_CONVERT = NONE, which is the same as omitting this clause. If you omit this clause, then the database first attempts to use Oracle Managed Files to generate file names. If you are not using Oracle Managed Files, then the database uses the PDB_FILE_NAME_CONVERT initialization parameter to generate file names. If this parameter is not set, then an error occurs. https://docs.oracle.com/database/121/SQLRF/statements_6010.htm#SQLRF55686

Topics

#PDB creation#OMF#PDB_FILE_NAME_CONVERT#CREATE_FILE_DEST

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice