题目内容

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

查看答案
更多问题

教师公正

前轮处倾

组织、参加反对党的基本理论、基本路线、基本纲领、基本经验、基本要求或者重大方针政策的集会、游行、示威等活动的,或者以组织讲座、论坛、报告会、座谈会等方式,反对党的基本理论、基本路线、基本纲领、基本经验、基本要求或者重大方针政策,造成严重不良影响的,对其他参加人员或者以提供信息、资料、财物、场地等方式支持上述活动者,情节较重的,给予()或()处分。

A. 严重警告
B. 撤销党内职务
C. 留党察看
D. 开除党籍

答案查题题库