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
I think the answer is BCD.
http://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_overview.htm#CEGFAHGI
The information gathered by SQL Test Case Builder includes the query being executed, table and index definitions (but not the actual data), PL/SQL functions, procedures, and packages, optimizer statistics, and initialization parameter settings.