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?
A.
A template needs to be associated with the task.
B.
A workload needs to be associated with the task.
C.
The partial or complete workload scope needs to be associated with the task.
D.
The type of structures (indexes, materialized views, or partitions) to be recommended
need to be specified for the task.