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.

单项选择题

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.

1Z0-032