Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?

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.)

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



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Laukik Kapadia

Laukik Kapadia

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.

iimax

iimax

you’re right

Magwai

Magwai

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.