Identify the correct sequence of steps.

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.

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, 4, 1

B.
3, 2, 1, 4

C.
2, 3, 4, 1

D.
4, 1, 3, 2



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Patty

Patty

Correct: 2341