Oracle 11G OCP 1Z0-053 24

(24)Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?(Choose all that apply.)

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

答案:(B、C、D)

解析:

《Performance Tuning》  16.6

SQL Test Case Builder收集的信息包括被执行的SQL语句、表和索引的定义(不是实际的数据)、PL/SQL过程、函数、包、优化器的统计、初始化参数的设置。

请使用浏览器的分享功能分享到微信等