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
Correct answer is : B, C & D
Answer E is incorrect because actual data is not being gathered by SQL Test Case Builder.
Because as per oracle administrator’s guide “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.”
Ref: http://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_overview.htm#CEGFAHGI
Regards.
you’re right
It is true
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.