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

單項選擇題

You create a new Automatic Database Diagnostic Monitor （ADDM） task： 
instance_analysis_mode_task. To view the ADDM report， you use the following command：  
SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；  
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. 
What would you do to achieve this？（）

A. Add a finding directive for the ADDM task.
B. Add a segment directive for the ADDM task.
C. Add a parameter directive for the ADDM task.
D. Disable the Segment Advisor from the Automatic Maintenance Task.

題目列表

你可能感興趣的試題

單項選擇題

The INV_HISTORY table is created using the command：  
SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0 
values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））；  
The following data has been inserted into the INV_HISTORY table ：  
INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000  
You would like to store the data belonging to the year 2006 in a single partition and issue the command：  
SQL> ALTER TABLE inv_history MERGE PARTITIONS 
FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py； 
What would be the outcome of this command？（）

A. It executes successfully，and the transition point is set to ’1-apr-2006’.
B. It executes successfully，and the transition point is set to ’15-apr-2006’.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values stored in the table.
微信掃碼免費搜題