Identify two situations in which the alert log file is updated.

Question

Options

• ARunning a query on a table returns ORA-600: Internal Error.
• BInserting a value into a table returns ORA-01722: invalid number.
• CCreating a table returns ORA-00955: name us already in used by an existing objects.
• DInserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.
• ERebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block

• A
  96% (24)
• D
  4% (1)

Explanation

The alert log is a chronological log of messages and errors, and includes the following items: *All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) *Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements *Messages and errors relating to the functions of shared server and dispatcher processes *Errors occurring during the automatic refresh of a materialized view *The values of all initialization parameters that had nondefault values at the time the database and instance start *The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.

No community discussion yet for this question.