多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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.
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题