题目内容

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 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.

查看答案
更多问题

(项目性能监控中的)图解控制方法

反应器转移程序执行完毕后开始吹氮。

A. 正确
B. 错误

集中监测系统对直流转辙机的监测点为()。

A. 继电器
B. 动作回线
C. 表示回线
D. 分线盘

()时,精密进近雷达管制员应当通知航空器复飞并说明原因。

A. 航空器在五边出现危险情况
B. 在有其它飞行冲突
C. 在没有及时收到塔台管制员的着陆许可
D. B和C

答案查题题库