ocp-391

QUESTION NO: 391
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.
Answer: B

---

检查SH 方案的运输表中执行的下列命令：
SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS(‘sh’, ‘customers_obe’,
‘(country_id, cust_state_province)’) FROM dual;
哪种说法描述了这个命令的意义？

B.它创建一个客户OBE表的虚拟隐藏列.

http://oracle.chinaitlab.com/production/734988_2.html

---