欢迎来到在线考试题库网 在线考试题库官网
logo
全部科目 > 微软认证考试 > MCITP > MCITP(70-444)

单项选择题

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.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题