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 
Answer: BCE 

答案应该是 BCD

16.6 Building SQL Test Cases

For many SQL-related problems, obtaining a reproducible test case makes it easier to resolve the problem. Starting with the 11g Release 1 (11.1), Oracle database contains the SQL Test Case Builder, which automates the somewhat difficult and time-consuming process of gathering and reproducing as much information as possible about a problem and the environment in which it occurred.

The objective of a SQL Test Case Builder is to capture the information pertaining to a SQL-related problem, along with the exact environment under which the problem occurred, so that the problem can be reproduced and tested on a separate Oracle database instance. Once the test case is ready, you can upload the problem to Oracle Support to enable support personnel to reproduce and troubleshoot the problem.

The information gathered by SQL Test Case Builder includes the query being executed, table and index definitions (butnot the actual data), PL/SQL functions, procedures, and packages, optimizer statistics, and initialization parameter settings.