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.