Which three are true about Oracle Managed Files (OMF)?

Which three are true about Oracle Managed Files (OMF)? (Choose three.)
A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
C. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
D. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.