多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

While tuning a SQL statement, 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 warning message in the alert log so that the DBA can perform statistics collection manually
正确答案:B
答案解析:
进入题库查看解析

微信扫一扫手机做题