Multiple choice technology databases

What file will give you Oracle instance status information?

  1. alert.ora

  2. init.ora

  3. tnsname.ora

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

The alert log file (alert.log or alert_.log) is the primary source for Oracle instance status information. It contains database startup/shutdown messages, error messages, checkpoint information, and critical events. The init.ora file contains initialization parameters, tnsnames.ora holds network connection details, and redo log files store transaction records - none provide instance status.

Keep practicing — related questions