You are a database developer. You plan to design a database solution by using SQL Server
2008. The database contains a table named SaverPlans that stores information about
savings plans. The table contains a column named MinBalance that stores the minimum
balance for a given plan. You need to ensure that each new savings plan, for which the
MinBalance value is unspecified, has a minimum balance of 1,000 U.S. dollars. You want to
achieve this goal by using the minimum amount of cost. What should you do?
A.
Use an INSERT trigger.
B.
Use the CHECK constraint.
C.
Use an UPDATE trigger.
D.
Use the DEFAULT constraint.