1Z0-050 · Question #43
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code: BEGIN…
The correct answer is B. A workload needs to be associated with the task. See the full explanation below for the reasoning.
Question
To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:
BEGIN dbms_advisor.create_task(dbms_advisor.sqlaccess_advisor,'TASK1'); END; / BEGIN dbms_advisor.set_task_parameter('TASK1','ANALYSIS_SCOPE','ALL'); dbms_advisor.set_task_parameter('TASK1','MODE','COMPREHENSIVE'); END; / BEGIN dbms_advisor.execute_task('TASK1'); dbms_output.put_line(dbms_advisor.get_task_script('TASK1')); END; / The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?
Options
- AA template needs to be associated with the task.
- BA workload needs to be associated with the task.
- CThe partial or complete workload scope needs to be associated with the task.
- DThe type of structures (indexes, materialized views, or partitions) to be recommended need to be
How the community answered
(53 responses)- A8% (4)
- B74% (39)
- C15% (8)
- D4% (2)
Community Discussion
No community discussion yet for this question.