移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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?()

发布日期:2021-11-25

You have a range-partitioned table in your databas...
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

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

Oracle认证考试

1Z0-053

去刷题