Which statement describes the consequence?

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?
Exhibit:

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.

Explanation:
sys@TEST1107> VAR tname VARCHAR2(60);
sys@TEST1107> BEGIN :tname := ‘my_instance_analysis_mode_task’;
2 DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,’Sg_directive’,’SCOTT’);
3 END;
4 /
PL/SQL procedure successfully completed.
sys@TEST1107> SELECT DBMS_ADVISOR.GET_TASK_REPORT(:tname, ‘TEXT’, ‘ALL’)
FROM
DUAL;
ERROR:
ORA-13631: The most recent execution of task my_instance_analysis_mode_task
contains no results.
ORA-06512: at “SYS.PRVT_ADVISOR”, line 3189
ORA-06512: at “SYS.DBMS_ADVISOR”, line 590
ORA-06512: at line 1
no rows selected