单项选择题

You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schemA.Examine the following steps:1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement.2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedurE.3. Execute the required queries on the CUSTOMERS tablE.4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement.Identify the correct sequence of steps.()
A.3,2,1,4
B.2,3,4,1
C.4,1,3,2
D.3,2,4,1

A.Examine
B.CREATE_EXTENDED_STATS
C.2.
D.SEED_COL_USAGE
E.3.
F.4.
G.REPORT_COL_USAGE
H.Identify
I.()
A.3,2,1,4
J.2,3,4,1
K.4,1,3,2
L.3,2,4,1