28.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.
Answer: C
参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_stats.htm#ARPLS68595
INCREMENTAL默认为FALSE，如果设置为TRUE，那么ORACLE只会扫描改变的分区，搜索信息会更快。C正确。
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.
Answer: C
参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_stats.htm#ARPLS68595
INCREMENTAL默认为FALSE，如果设置为TRUE，那么ORACLE只会扫描改变的分区，搜索信息会更快。C正确。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2122770/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q27
下一篇：
1Z0-053 V13.02 Q32
请登录后发表评论
登录
全部评论
