Oracle
1Z0-050 · Question #47
1Z0-050 Question #47: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #47. The question stem and answer options stay visible for context.
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
Unlock 1Z0-050 to see the answer
You've previewed enough free 1Z0-050 questions. Unlock 1Z0-050 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.