Oracle
1Z0-050 · Question #47
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 :=…
The correct answer is C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not. See the full explanation below for the reasoning.
Question
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
Options
- AThe ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
- BThe ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
- CThe PL/SQL block produces an error because the my_instance_analysis_mode_task task has not
- DAll subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the
How the community answered
(29 responses)- A7% (2)
- B3% (1)
- C79% (23)
- D10% (3)
Community Discussion
No community discussion yet for this question.