试题详情
- 单项选择题 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?()
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.
- C
关注下方微信公众号,在线模考后查看
热门试题