Multiple choice

Where can you find the non default parameters when the instance is started?

  1. Alert log

  2. Online redo log

  3. Archiver redo log

  4. System user's trace file
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When an Oracle instance starts with non-default initialization parameters, these are recorded in the alert log file. The alert log serves as the primary diagnostic log for instance startup messages, parameter changes, and critical events. Options B, C, and D are incorrect because online redo logs, archiver logs, and trace files serve different purposes: redo logs record transaction changes, archiver logs store archived redo data, and trace files capture session-level diagnostics.

Keep practicing — related questions