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
Explanation:
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.
B, C and D are correct:
https://docs.oracle.com/database/121/TGSQL/tgsql_stcb.htm#TGSQL94870
What SQL Test Case Builder Captures
SQL Test Case Builder captures permanent information such as the query being executed, table and index definitions (but not the actual data), PL/SQL packages and program units, optimizer statistics, SQL plan baselines, and initialization parameter settings. Starting in Oracle Database 12c, SQL Test Case Builder also captures and replays transient information, including information only available as part of statement execution.