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

Oracle认证考试

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

Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?()

  • A、Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
  • B、Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
  • C、Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
  • D、Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
  • E、Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
正确答案:A,C,D
答案解析:
进入题库查看解析

微信扫一扫手机做题