多项选择题

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems？（）

A. ADR diagnostic files
B. all the optimizer statistics
C. initialization parameter settings
D. PL/SQL functions，procedures，and packages
E. the table and index definitions and actual data

点击查看答案

上一题目录下一题

相关考题

单项选择题

Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure？（）

A. only encryption and compression settings for all SecureFile LOBs
B. only encryption and deduplication settings for only SecureFile CLOBs
C. deduplication，encryption，and compression settings for all SecureFile LOBs
D. deduplication，encryption，and compression settings only for SecureFile CLOBs

单项选择题

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.