OCP-1Z0-053-V13 02-24题

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

 

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

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_overview.htm#PFGRF16001

此题答案有误，E错误，不包含actual data。

正确答案应该为BCD

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 2 (11.2), 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.

SQL Test Case Builder captures information pertaining to a SQL-related problem, along with the exact environment under which the problem occurred, so that you can reproduce and test the problem on a separate database. After 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 (but not the actual data), PL/SQL functions, procedures, and packages, optimizer statistics, and initialization parameter settings.

 

           

给我老师的人工智能教程打call！http://blog.csdn.net/jiangjunshow