053-3 While tuning a SQLstatement, the SQL Tuning Advisor finds an existing SQL profile for

QUESTION 3

While tuning a SQLstatement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?

A. It updates the existing SQL profiles with current statistics.

B. It makes the statistics information available to GATHER_STATS_JOB.

C. It initiates the statistics collection process by running GATHER_STATS_JOB.

D. It logs a warningmessage in the alert log so that the DBA can perform statistics collectionmanually. 

Correct Answer: B
Section: 

当优化器发现存在sql的优化配置会怎么做

A.更新这个优化配置，显然不对，它并不能保证新的比原来的更好

B.保留可用 对的

C.通过拉起GATHER_STATS_JOB运行统计信息搜集进程 错

D.警告写入alert 错的没边