Exam 1z0-053 topic 15 question 40 discussion

Actual exam question from Oracle's 1z0-053

Question #: 40
Topic #: 15

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.

Show Suggested Answer

Suggested Answer: B 🗳️
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.

by [deleted] at April 4, 2025, 8:19 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!