You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that has a table named CK_StockOnHand.
CK_StockOnHand contains a column named CK_Price.
A new Domain.com policy states that the value in CK_Price cannot be
decreased by more than 10 percent in any single database operation.
However, ad hoc queries and various other methods are used to update CK_Price.
You need to make sure that the Domain.com policy is being complied with.
What should you do?
A.
You should consider developing a trigger which rolls back non-Domain.com policy compliant changes to CK_Price.
B.
You should consider developing a view which rolls back non-Domain.com policy compliant changes to CK_Price.
C.
You should consider developing a stored procedure which rolls back non-Domain.com policy compliant changes to CK_Price.
D.
You should consider developing a primary key constraint to a table which only contains valid prices on CK_Price.