1Z0-053第一题

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
Explain：
当部署一个新的应用模块时，软件开发商已经为新的 SQL 语句加载了合适的（经过测试的）SQL计划基线。也就是说新的应用中的所有sql 语句的执行计划已经产生，并属于计划基线了。
A 对,给出了一个基本概念：计划基线经过一段时期的进化可以带来更好的性能。
C 对,新的SQL 语句将使用这些已知的（known）计划基线，从而直接受益。