nerdexam
Oracle

1Z0-052 · Question #103

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON MET

Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #103. The question stem and answer options stay visible for context.

Performing Database Maintenance

Question

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, you executed the following command:

SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE ----------------------------------------------- ---------------- Tablespace [TEST] is [28 perce 28.125 nt] full 28.125 What could be the reason for the elimination of the other rows in the output?

Exhibit

1Z0-052 question #103 exhibit

Options

  • AAn Automatic Workload Repository snapshot has been taken recently.
  • BThe non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
  • CThe threshold alerts conditions are cleared and the alerts are transferred to BA_ALERT_HISTORY.
  • DThe threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY

Unlock 1Z0-052 to see the answer

You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#DBA_OUTSTANDING_ALERTS#threshold alerts#DBA_ALERT_HISTORY#server alerts
Full 1Z0-052 Practice