移动端

  • 题王微信公众号

    题王微信公众号

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

单选题

Consider the following statement:   SQL> EXECUTE DBMS_STATS.GATHER_SHEMA_STATS (-  2> ownname => ‘OE’, -  3> estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, -  4> method opt => ‘for all columns size AUTO’);   What is the effect of ‘for all columns size AUTO’ of the METHOD_OPT option?()

发布日期:2022-06-22

Consider the following statement:   SQL> EXECUTE D...
A

The Oracle server creates a new histogram based on existing histogram definitions for all table, column, and index statistics for the OE schema.

B

The Oracle server creates a histogram based on data distribution regardless of how the application uses the column/s for all table, column, and index statistics for the OE schema.

C

The Oracle server creates a histogram based on data and application usage of the column/s for all table, column, and index statistics for the OE schema.

D

The Oracle server creates a histogram based on application usage, regardless of data distribution, for all table, column, and index statistics for the OE schema.

标签: "暂无标签"

题王网让考试变得更简单

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