[单选]

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. A SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect.
Which action should be performed？（）

You need to create a partitioned table to store historical data and you issued the following command: What is the outcome of the above command?（） It returns an error because the range partitions P1 and P2 should be of the same range.。 It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions.。 It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each.。 It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.。 比较几种疗效相同的干预方案所需成本应用药物经济学研究方法是（） 最小成本法。 最大成本法。 成本效果分祈。 成本效益分析。 成本效用分析。 What command is used to reset a database to a previous incarnation？（）    reset incarnation。  incarnation reset。  reset database to incarnation。  reset database incarnation。  reset databse incarnation number。 按危机来源的不同，小企业可能遇到多种危机，除了（）。 供应危机。 财务危机。 品牌危机。 战略危机。 In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB  DB_CACHE_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  STATISTICS_LEVEL = BASIC  PGA_AGGREGATE_TARGET = 0  You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（） The STATISTICS_LEVEL initialization parameter is set to BASIC。 The PGA_AGGREGATE_TARGET initialization parameter is set to zero.。 The SGA_MAX_SIZE initialization parameter is set to less than 20 GB。 The DB_CACHE_SIZE initialization parameter is set to less than 5 GB。 The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.。

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005.You work as a database administrator for your company. A SQL Server 2005 database is utilized in your company. And a table named Inventory is contained by the database. A column named Price is included by the table. According to the company policy， you cannot reduce more than 10 percent the value in the Price column in any single database operation. Through many kinds of method， the company makes updates to the Price column. For instance， the utilization of ad hoc queries is one of the methods. Since you are the database administrator， you should confirm that this company policy takes its effect.
Which action should be performed？（）