多项选择题

Which two statements are true about alerts（）

A.Clearing an alert sends the alert to the alert history.
B.Response actions cannot be specified with server-generated alerts.
C.The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view.
D.Server-generated alerts notify the problems that cannot be resolved automatically and requireadministrators to be notified.

点击查看答案&解析

上一题目录下一题

相关考题

单项选择题

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 percent]full 28.125
What could be the reason for the elimination of the other rows in the output（）

A.An Automatic Workload Repository snapshot has been taken recently.
B.The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C.The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D.The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

单项选择题

The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for all objects.
Which statement is true in this scenario（）

A.The statistics collection continues until all objects are processed.
B.The job is terminated and the statistics collected are restored to a time before the job started.
C.This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
D.The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened.

多项选择题

Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.
You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day.
Choose two actions any of which can be referred to first to diagnose the problem. （）

A.Use the Active Session History report.
B.Use the AWR Compare Periods report.
C.Use an ADDM analysis between 7 PM and 9 PM of the previous day.
D.Use the AWR Compare Period report between 7 PM and 9 PM of the previous day.