Multiple choice technology databases

If no e-mail address is specified, where will alert information be displayed?

  1. In the DBA_ALERTS data dictionary view

  2. In the V$ALERTS dynamic performance view
  3. In the EM Database Control main screen

  4. No alert information is sent or displayed.

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When no email address is configured, EM Database Control displays alert information on its main console screen. The alerts remain visible in the EM interface for administrators to review. Alerts are not stored in data dictionary views like DBA_ALERTS or dynamic performance views like V$ALERTS when no email is specified.

AI explanation

When no e-mail address is configured for notifications, Oracle's Enterprise Manager Database Control still records and displays outstanding alerts directly on its main console screen so the DBA can see them when logging in. The DBA_ALERTS/V$ALERTS-style views aren't the actual mechanism EM uses for surfacing these, and alerts are never simply discarded — they're just not emailed.