Oracle 11G OCP 1Z0-053 490

（490）View the Exhibit.

Examine the following command that is executed for the TRANSPORT table in the SH schema:


SQL>SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe', '(country_id,cust_state_province)') FROM dual;

Which statement describes the significance of this command?

A. It collects statistics into the pending area in the data dictionary.

B. It creates a virtual hidden column in the CUSTOMERS_OBE table.

C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.

D. It creates a histogram to hold skewed information about the data in the columns.

答案：（B）

解析：

DBMS_STATS.CREATE_EXTENDED_STATS,为用户指定的表中的列组或表达式在系统中创建列statistics entry.

当用户或自动统计信息收集作业收集表的统计信息时,这个扩展的统计信息将被收集.

这种统计信息称为"extended statistics"

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1305132/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1305132/