Multiple choice technology databases

Which initialization parameter specifies the location of the alert log file

  1. UTL_FILE_DIR

  2. USER_DUMP_DEST

  3. LOG_ARCHIVE_DEST

  4. BACKGROUND_DUMP_DEST
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

BACKGROUND_DUMP_DEST is the initialization parameter that specifies the location where the alert log file and background trace files are written. UTL_FILE_DIR is for file directory access, USER_DUMP_DEST is for user process trace files, and LOG_ARCHIVE_DEST is for archived redo log files.

Keep practicing — related questions