单项选择题
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command：
SQL>CREATE INDEX ord_custname_ix ON orders（custname）；
The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task？（）
A. disabling the index
B. making the index invisible
C. making the index unusable
D. using the MONITORING USAGE clause for the index
相关考题
-
单项选择题
A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition？（）
A. It remains valid.
B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used. -
单项选择题
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.
