试题详情
- 单项选择题 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
- C
关注下方微信公众号，在线模考后查看
热门试题
- TheEMPtablecontainst
- （）函数不能用于日期/时间类型。
- You have
- Which three statemen
- Your x86-based&
- Exhibit， Viewi
- You create&ens
- Your database&
- Examine the descrip
- You are
- You want
- Users in
- You notice a high n
- You performed&
- 举出ORACLE提出的独特的数据库对象的
- 以下关于包（Package）的说法，正确
- Thefollowingcommandi
- You write̳
- Which statements are
- You are managing an