Oracle
1Z0-050 · Question #43
1Z0-050 Question #43: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-050 to reveal the answer and full explanation for question #43. The question stem and answer options stay visible for context.
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
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.