(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过程、函数、包、优化器的统计、初始化参数的设置。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1248919/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1248919/