移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

多选题

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?()

发布日期:2022-06-19

Examine this command: SQL > exec DBMS_STATS.SET_TA...
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.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!