1Z0-052 · Question #18
Which two statements are true about alerts? (Choose two.)
The correct answer is A. Clearing an alert sends the alert to the alert history D. Server-generated alerts notify the problems that cannot be resolved automatically and require. In Oracle, clearing an alert archives it to the alert history table, and server-generated alerts are used to notify DBAs of problems that require manual intervention.
Question
Which two statements are true about alerts? (Choose two.)
Options
- AClearing an alert sends the alert to the alert history
- BResponse actions cannot be specified with server-generated alerts
- CThe nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view
- DServer-generated alerts notify the problems that cannot be resolved automatically and require
How the community answered
(24 responses)- A92% (22)
- B4% (1)
- C4% (1)
Why each option
In Oracle, clearing an alert archives it to the alert history table, and server-generated alerts are used to notify DBAs of problems that require manual intervention.
When a DBA clears an alert via Oracle Enterprise Manager or DBMS_SERVER_ALERT, Oracle moves the alert record from DBA_OUTSTANDING_ALERTS to DBA_ALERT_HISTORY, preserving a historical record of the event.
Response actions such as custom PL/SQL callout procedures can be registered and associated with server-generated alerts using the DBMS_SERVER_ALERT package, making this statement false.
Nonthreshold (stateless) alerts do not persist in DBA_OUTSTANDING_ALERTS because they have no ongoing outstanding state to track; they are written directly to DBA_ALERT_HISTORY at the time they are raised.
Server-generated alerts are designed to inform DBAs of critical conditions - such as tablespace usage threshold breaches or session wait bottlenecks - that Oracle cannot resolve automatically and that require human investigation and action.
Concept tested: Oracle server-generated alerts and alert lifecycle management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/monitoring-the-database.html
Topics
Community Discussion
No community discussion yet for this question.