OCP-1Z0-053-V12.02-509题

509.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

Answer: CD

 答案解析：

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

• 使用SQL 优化指导可分析SQL 语句，并获得性能建议。

• SQL 优化指导分析的来源：

– 顶级活动：分析当前处于活动状态的顶级 SQL 语句

– SQL 优化集：分析用户提供的一组 SQL 语句

– 以往的SQL (AWR)：分析 AWR 快照收集的 SQL 语句中的语句

排除法，选CD

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 statementsand SQL Tuning Sets can be provided as input to the

SQL Tuning Advisor.