日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

單項(xiàng)選擇題

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.

微信掃碼免費(fèi)搜題