Oracle 11G OCP 1Z0-053 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

答案:(A, C, D)

解析:

《2 Day DBA》 10.3.2

可以对下面的输入使用SQL Tuning Advisor:

1. Top Activity

2. Historical SQL

3. SQL Tuning Set

请使用浏览器的分享功能分享到微信等