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 creates a virtual hidden column in the CUSTOMERS_OBE table.
B.
It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.
C.
It creates a histogram to hold skewed information about the data in the columns.
D.
It collects statistics into the pending area in the data dictionary.
Explanation: