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

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

A.
Running a query on a table returns ORA-600: Internal Error.

B.
Inserting a value into a table returns ORA-01722: invalid number.

C.
Creating a table returns ORA-00955: name us already in used by an existing objects.

D.
Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

E.
Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE
data block corrupted (file # 14, block # 50) error.

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)
that occur
* 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
Note:
* 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.