Multiple choice technology databases

Which two parameters can be set to tell the Oracle to use OMF (Oracle Managed Files)?

  1. DB_CREATE_FILE_DEST

  2. DB_CREATE_ONLINE_LOG_n

  3. USER_DUMP_DEST

  4. LOG_ARCHIVE_DEST
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DB_CREATE_FILE_DEST is the primary parameter used to enable Oracle Managed Files (OMF) by specifying the default directory for datafiles. Other parameters like USER_DUMP_DEST and LOG_ARCHIVE_DEST serve administrative purposes and do not initialize OMF for database files.

Keep practicing — related questions