【单项选择题】
To generate recommendations to improve the performance of a set of SQL queries in an application， you execute the following blocks of code：  <br /> BEGIN <br /> dbms_advisor.create_task（dbms_advisor.sqlaccess_advisor，’TASK1’）； <br /> END； / <br /> BEGIN <br /> dbms_advisor.set_task_parameter（’TASK1’，’ANALYSIS_SCOPE’，’ALL’）； dbms_advisor.set_task_parameter（’TASK1’，’MODE’，’COMPREHENSIVE’）； <br /> END； <br /> / <br /> BEGIN <br /> dbms_advisor.execute_task（’TASK1’）； <br /> dbms_output.put_line（dbms_advisor.get_task_script（’TASK1’））； <br /> END； <br /> / <br /> The blocks of code execute successfully；however，you do not get the required outcome
A、A. A template needs to be associated with the task.
B、B. A workload needs to be associated with the task.
C、C. The partial or complete workload scope needs to be associated with the task.
D、D. The type of structures （indexes， materialized views， or partitions） to be recommended need to be specified for the task.
查看正确答案
