nerdexam
Oracle

1Z0-063 · Question #36

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…

The correct answer is B. 2, 3, 4, 1. See the full explanation below for the reasoning.

Question

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 SELECTDBMS_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.reportwcol_usage('SH', 'customers') from dual statement. Identify the correct sequence of steps.

Options

  • A3, 2, 1, 4
  • B2, 3, 4, 1
  • C4, 1, 3, 2
  • D3, 2, 4, 1

How the community answered

(47 responses)
  • A
    11% (5)
  • B
    81% (38)
  • C
    6% (3)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice