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.