You are a database administrator for your company. The company uses a SQL Server 2008
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.
You should develop a trigger which rolls back changes to the Price column which breaks company policy.
B.
On the Price column, you should develop a primary key constraint to a table which includes valid prices.
C.
You should develop a view which rolls back changes to the Price column which breaks company policy.
D.
You should develop a stored procedure which allows changes to the Price column which breaks company policy.