Exam 1z0-053 topic 13 question 4 discussion

Actual exam question from Oracle's 1z0-053

Question #: 4
Topic #: 13

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter.
The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS('SH','SALES',GRANULARITY=>'GLOBAL');
You need statistics to be collected more quickly.
What can you do to achieve this?

A. Set DYNAMIC_SAMPLING to level 4.
B. Set the STATISTICS_LEVEL parameter to BASIC.
C. Set the INCREMENTAL value to TRUE for the partition table.
D. Increase the value of STALE_PERCENT for the partition table.

Show Suggested Answer

Suggested Answer: C 🗳️
Oracle will update the global table statistics by scanning only the partitions that have been changed instead of the entire table if the following conditions hold:
✑ INCREMENTAL value for the partitioned table is set to TRUE PUBLISH value for the partitioned table is set to TRUE; User specifies AUTO_SAMPLE_SIZE for
ESTIMATE_PERCENT and AUTO for GRANULARITY when gathering statistics on the table
If the INCREMENTAL value for the partitioned table was set to FALSE (default value), a full table scan is used to maintain the global statistics which is a much more resource intensive and time-consuming operation for large tables.

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

Comments

Submit Cancel

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