2 Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)

最新推荐文章于 2017-05-02 10:48:28 发布

EVISWANG

最新推荐文章于 2017-05-02 10:48:28 发布

阅读量1.3k

点赞数

分类专栏： OCP 053

本文链接：https://blog.csdn.net/EVISWANG/article/details/50259281

版权

OCP 053 专栏收录该内容

86 篇文章 0 订阅

订阅专栏

2
Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all that apply.)
A. A single SQL statement provided by a user
B. An existing SQL Tuning Set (STS)
C. A preprocessed Database Replay workload
D. A schema name

E. SQL statement identified in EM as using excessive resources

Correct Answer: CD
Section: (none)
Explanation
Explanation/Reference:
Explanation:
You cannot use Database Replay workloads or an entire schema name as input to the SQL Tuning
Advisor. However, you can specify single SQL statements.
A, B, and E are incorrect because single SQL statements and SQL Tuning Sets can be provided as input
to the SQL Tuning Advisor.