欢迎来到PP题库网 PP题库官网
logo
全部科目 > Oracle认证考试 > 1Z0-053

单项选择题

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.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题