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.