Which of the following cannot be used as input to the SQL Tuning Advisor?

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

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *