【12c-062】OCP 062考试题库最新考试真题-第23题

文章来源：更新时间:2019/4/19 10:34:02

在线老师点击咨询：

最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！

我要咨询

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

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

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

OCP解析群资料分享：1015267481 验证：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。