493.Which three statements about performance analysis by SQL Performance Analyzer are true?(Choose three.)
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
Answer: ABD
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_intro.htm#RATUG174
哪三项关于SQL性能分析器的性能分析是正确的？
A. It detects changes in SQL execution plans.
B. It produces results that can be used to create the SQL plan baseline.
C. The importance of SQL statements is based on the size of the objects accessed.
D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E. It shows only the overall impact on workload and not the net SQL impact on workload.
Answer: ABD
参考：http://docs.oracle.com/cd/E11882_01/server.112/e41481/spa_intro.htm#RATUG174
哪三项关于SQL性能分析器的性能分析是正确的？
1、检测到SQL执行计划的改变；
2、产生的结果可以用来创建SQL计划基线；
3、生成运行SQL优化指导的建议，来调整退化的SQL语句；来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2124443/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q487
下一篇：
1Z0-053 V13.02 Q255
请登录后发表评论
登录
全部评论
