Oracle-12c OCP认证062考试题库解析-第23题

时间：2019-06-27 来源：

2018年OCP 11g考试原题解析已经讲解30多次课，500多道考试原题，最终达到98%以上的考题覆盖度及95%以上的考试通过率。

2019年OCP 11g将升级到12c，OCP 12c考试解析免费公开课也已经开始了，欢迎大家收看!

OCP解析公开课时间：【每周五晚8点】

OCP解析群资料分享：569933648 验证：ocp

另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与

-------------------------------------------------------

QUESTION 23

Examine the query and its output:

SQL> SELECT REASON, metric_value FROM dba_outstanding_alerts;

REASON METRIC_VALUE

----------------------------------- -------------------

Tablespace [TEST] is [28 perce 28.125

nt] full

Metrics "Current Logons Count" 29

Metrics "Database Time Spent 99.0375405

waiting (%)" is at 99.03754 for

event class "Application"

db_recovery_file_dest_size of 974294967296 bytes is 97.298 used and has 116228096

remaining bytes available.

After 30 minutes, you execute the same query:

SQL> SELECT reason, metric_value FROM dba_outstanding_alerets;

REASON METRIC_VALUE

------------------------------ ---------------

Tablespace [TEST] is [28 percs 28.125

nt] full

What might have caused three of the alerts to disappear?

A. The threshold alerts were cleared and transferred to dba_alert_history.

B. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second

C. An Automatic Database Diagnostic Monitor (ADDM) report was generated before the execution of t he second query.

D. The database instance was restarted before the execution of t he second query.

Correct Answer:A

Section: (none)

Explanation 有状态预警显示在 DBA_OUTSTANDING_ALERTS 中，清空后会转到

DBA_ALERT_HISTORY。