微软认证考试

You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased 

题目

You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means， including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do？（）

  • A、Create a trigger that rolls back changes to the Price column that violate company policy.
  • B、Create a stored procedure that disallows changes to the Price column that violate company policy.
  • C、On the Price column， create a check constraint that requires a specified minimum value.
  • D、On the Price column， create a foreign key constraint to a table that contains valid prices.
如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Lily, nice to see you ! ______ to England ?－－－－ Yes. And I will come back in a week. ( )

A、 Have you gone

B、 Are you going

C、 Have you been

D、 Did you go


参考答案：B

第2题：

在SQL Server 2000中，要对数据库GoodsDB进行一次差异备份，将其备份到设备Backup 1上(该设备已建立好)，并要求该次备份操作清除Backupl中己有的备份内容。下列能实现该备份要求的语句是

A．BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITH NOINIT

B．BACKUP DATABASE GoodsDB TO Backupl WITH DIFFERENTIAL,NOINIT

C．BACKUP DATABASE GoodsDB TO Backupl DIFFERENTIAL,WITHINIT

D．BACKUP DATABA息E GoodsDB TO Backupl WITH DIFFERENTIAL,INIT


正确答案：D

第3题：

These books, ________ at any bookshop, will give you all the information you need.

(A) you can get

(B) that you can get

(C) what you can get

(D) which you can get


正确答案：D
解答参考：D.定语从句题。这是一个非限制性定语从句作为插入语直接跟在先行词books的后面，非限制性定语从句修饰物只能由which 引导。【译文】 这些书你可以在任何商店买到，并且能给你想要的任何信息。

第4题：

The following hints may help you stay energized, or at least()until you can make the time for rest.

A、 get you going

B、 get you go

C、 get you went


参考答案：A

第5题：

It’s kind () me the way to the station.

A、of you to tell

B、of you telling

C、for you to tell

D、for you telling


参考答案：A

第6题：

Are you still here? You were here half an hour ago. Who( )for?

A、were you waiting

B、are you waiting

C、did you wait

D、do you wait


正确答案:B

第7题：

7．—Happy birthday to you !

—__________．

A． You are good

B． Great

C． You are right

D． Thank you


正确答案：D
7．D【解析】用“Thank you．”回答别人对自己的祝福．

第8题：

Those books, () at any bookshop, will give you all information you need.

A、you can get

B、that you can get

C、what you can get

D、which you can get


参考答案：D

第9题：

When you are young you think you are ( ): you feel you can achieve anything.

A. vigorous

B. interesting

C. indispensable

D. invincible


参考答案：D

第10题：

______ that dress when I first saw you at the station?

A、Were you wearing

B、Have you worn

C、Did you wear

D、Do you wear


正确答案:A

更多相关问题
相关内容