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
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.
The explanation reads – “A, B, and E are incorrect ” instead it should be “A, B, and E are correct”
Read the question again!
C, D – is correct answer. See
17.4.1 Input Sources
http://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJBGIE
17.2 SQL Tuning Advisor
http://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#CHDJDFGE