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

题目

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？（）

A、A stored procedure should be created， and changes are disallowed by the procedure to the Price column that violates company policy.
B、On the Price column， a check constraint should be created， and a specified minimum value is required by the check constraint.
C、A trigger should be created， and changes are rolled back by the trigger to the Price column that violates company policy.
D、On the Price column， a foreign key constraint is created to a table that valid prices are included.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第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题：

7．—Happy birthday to you !

—__________．

A． You are good

B． Great

C． You are right

D． Thank you

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

第3题：

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

(A) you can get

(B) that you can get

(D) which you can get

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

第4题：

______ 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

第5题：

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

A. vigorous

B. interesting

C. indispensable

D. invincible

参考答案：D

第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题：

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

第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题：

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

第10题：

听力原文：If you lose your bank notes, the chance for you to get them back is not high.

(10)

A．If you lose your bank notes, you will not get them back.

B．If you lose your bank notes, you will get compensation.

C．If you lose your bank notes, you can get them back soon.

D．If you lose your bank notes, most probably, you will not get them back.

正确答案：D
解析：单句意思为“如果你丢失了银行支票，你找回它的机会不大。”

You are a profes

题目

相似问题和答案

更多相关问题

相关内容