Which three statements are true about server-generated alerts?

(A) This is the primary definition of a server-generated alert; it is a mechanism for the database to proactively notify administrators of current or impending problems.
(C) Critical server-generated alerts, such as "Tablespace is Full" or internal errors, are written to the human-readable alert log file (alert.log) for diagnosis and historical record-keeping.
(F) The database's manageability framework, including advisors like ADDM, can raise alerts that contain specific findings and recommendations for how to resolve the underlying problem.

B. This is incorrect. Many alerts, especially those generated by health checks or ADDM, explicitly provide suggestions for correction.
D. This is incorrect because of the word "only". Alerts can also be viewed by querying data dictionary views like DBAOUTSTANDINGALERTS and DBAALERTHISTORY.
E. This statement is an overgeneralization. While many alerts are threshold-based and configured with this package, some are event-based (e.g., block corruption) and do not have configurable thresholds.

1. Oracle Corporation. (2019). Oracle Database Concepts, 19c. Chapter 7, "Oracle Database Manageability", Section "Problem Detection and Self-Tuning". This section describes the proactive alert system.

2. Oracle Corporation. (2019). Oracle Database Administrator's Guide, 19c. Chapter 7, "Monitoring the Database", Section "Managing Server-Generated Alerts". This section confirms alerts can provide recommendations and are viewed in multiple ways.

3. Oracle Corporation. (2019). Oracle Database Administrator's Guide, 19c. Chapter 13, "Managing Diagnostic Data", Section "About the Alert Log". This section describes how significant events and errors, including alerts, are written to the alert log.