ocp-426

QUESTION NO: 426
View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.
You executed the following commands:
SQL> VAR tname VARCHAR2(60);
SQL> BEGIN
:tname := ‘my_instance_analysis_mode_task’;
DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,’Sg_directive’,’SCOTT’);
END;
Which statement describes the consequence?

A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been
reset to its initial state.
D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the
Segment Advisor suggestions for the SCOTT schema.
Answer: C

---

查看图表，检查自动数据库诊断监视器（ ADDM）任务。

C.PL / SQL块产生一个错误，因为“我的实例分析模式任务”任务一直没有重置到其初始状态。

---