可学答题网 > 问答 > 1Z0-060题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Examine this command: SQL > exec D


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.
参考答案
参考解析:
分类:1Z0-060题库