1Z0-083 · Question #83
1Z0-083 Question #83: Real Exam Question with Answer & Explanation
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 PDB_FILE_NAME_C
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
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
Community Discussion
No community discussion yet for this question.