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(lsh\ ‘customers^be1, ‘(countryjd,
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 CUSTOMERSjDBE 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.