1Z0-083 practice question 16 of 35

Choose two. Which two are true about server-generated alerts?

Full set: 286 questions
Answer options
A: Stateless alerts can be cleared manually.
B: Stateless alerts are automatically cleared after one day.
C: Stateful alerts are purged automatically from the alert history after one day.
D: Stateless alerts can be purged manually from the alert history. Correct answer
E: Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert. Correct answer
Correct Answer:
D. Stateless alerts can be purged manually from the alert history.; E. Stateful alerts must be cleared by a DBA to resolve the problem identified in the alert.
Explanation

Server-generated alerts are categorized as stateful or stateless. Stateful alerts (e.g., Tablespace Full) represent an ongoing condition that persists until a DBA resolves the underlying problem; clearing the alert requires this resolution. Stateless alerts (e.g., Snapshot Too Old) represent a point-in-time event and are automatically moved from the outstanding alerts view to the alert history after 24 hours. A DBA can manually purge any alert, including stateless ones, from the alert history using the DBMSSERVERALERT.PURGE procedure to manage its size.

Why Incorrect

A. Stateless alerts are not "cleared" manually because they represent a past event, not an ongoing state. They are removed automatically from the active view.
B. Stateless alerts

References

1. Oracle Database 19c Administrator’s Guide, ch. “Managing Alerts and Thresholds”, sec. “Stateful and Stateless Alerts” (definition of clearing vs. purging).

2. Oracle Database Reference 19c, view DBAALERTHISTORY description (default purge: 1 day stateless, 7 days stateful).

Scroll to Top