EXAM A
QUESTION 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.
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
在部署一个新的应用程序模块,软件供应商的船舶的应用软件
随着新的信息被引入适当的SQL计划基线。哪两家陈述描述
后果
a.计划基线可以随着时间的演变,产生更好的性能。
c.新的SQL语句的初步运行是众所周知的标准测试配置下产生良好的绩效计划
原文:http://blog.csdn.net/xuejiayue1105/article/details/48769313