可学答题网 > 问答 > 1Z0-053题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You have a range-parti


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
参考答案
参考解析:
分类:1Z0-053题库
相关推荐

1、You have a server&ensp

You have a server that runs Windows Server 2008 R2. You plan to install Exchange Server&en...

2、You have a single&ensp

You have a single network segment. All servers run Windows Server 2003 Service Pack 2 (SP...

3、You have a domain&ensp

You have a domain controller named Server1 that runs Windows Server 2008 R2.    You&e...

4、You have a single&ensp

You have a single Active Directory directory service forest named contoso.com. You create baseline&e...

5、You have a single&ensp

You have a single Active Directory directory service domain. All user accounts in the sales&ens...

6、You have a server&ensp

You have a server named Server1 that runs Windows Server 2012 R2. Server1 has the Hyper-V&...