You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that has a table named ABC_Training. ABC_ Training contains a column named
ABC_Distance. A new ABC.com training policy states that the training (ie. The ABC_Distance
column in the ABC_Training table) cannot be increased or decreased by more than 3%.
How should you implement the ABC Training Policy?
A.
You should consider developing a view which rolls back non-compliant ABC.com policy
changes to ABC_Distance.
B.
You should consider developing a stored procedure which rolls back non-compliant ABC.com
policy compliant changes to the ABC_Distance column.
C.
You should consider developing a primary key constraint to the ABC_training table which only
contains valid values on ABC_Distance.
D.
You should consider developing a create trigger which rolls back non-compliant ABC.com
policy changes to the ABC_Distance column.
E.
You should consider developing an update trigger which rolls back non-compliant ABC.com
policy changes to the ABC_Distance column.
F.
You should consider developing a delete trigger which rolls back non-compliant ABC.com policy
changes to the ABC_Distance column.
Explanation: