Oracle_11g_ocp_053_001

1.While deploying a new application module, the software vendor ships the application software along

with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe

the consequences? (Choose two.)

A. The plan baselines can be evolved over time to produce better performance.

B. The newly generated plans are directly placed into the SQL plan baseline without being verified.

C. The new SQL statements initially run with the plans that are known to produce good performance

under standard test configuration.

D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline

has been imported.

Answer: AC

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/16369811

当部署一个新的应用模块时，软件供应商与用于被引入的新SQL的适当的SQL计划基线一起运送应用软件。哪两个语句描述了后果？ 

A, 计划基线可以随着时间的推移演变，产生更好的性能。

C,新的SQL语句最初与计划一起运行，该计划在标准测试配置下已知能产生良好的性能。

 新应用程序部署：部署新的应用程序模块意味着在系统中引入新的 SQL 语句。软件供应商可以将应用程序软件与新引入的SQL 语句的相应SQL 计划基线一起提供。由于存在计划基线，新的SQL 语句最初将与已知在标准测试配置下具有良好性能的计划一起运行。但是，如果客户系统配置与测试配置有很大的差异，则计划基线可随时间演化以产生更好的性能。

-------------------转载文章，待研究---------------------------