053-24

最新推荐文章于 2025-12-20 13:10:13 发布

转载最新推荐文章于 2025-12-20 13:10:13 发布 · 77 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Babylon/p/8205961.html

文章标签：

#数据库

本文详细介绍了SQLTestCaseBuilder在解决SQL相关问题时所收集的信息类型，包括执行的查询、表和索引定义（但不包括实际数据）、PL/SQL函数、过程和包、优化器统计信息以及初始化参数设置。

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

资料中答案有问题，应该是BCD
https://docs.oracle.com/cd/E11882_01/server.112/e41573/sql_overview.htm#PFGRF16001
官方文档原文
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.

转载于:https://www.cnblogs.com/Babylon/p/8205961.html