Which statement describes the significance of this command?

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?
Exhibit:

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.

Explanation:
DBMS_STATS.CREATE_EXTENDED_STATS Function
Creates a virtual column for a user specified column group or an expression in a table
This function creates a column statistics entry in the system for a user specified column
group or an expression in a table. Statistics for this extension will be gathered when user or
auto statistics gathering job gathers statistics for the table. We call statistics for such an
extension, “extended statistics”. This function returns the name of this newly created entry
for the extension.