Microsoft
70-451 · Question #96
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…
The correct answer is D. Use an INSERT trigger. See the full explanation below for the reasoning.
Question
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?
Options
- AUse the DEFAULT constraint.
- BUse an UPDATE trigger.
- CUse the CHECK constraint.
- DUse an INSERT trigger.
How the community answered
(25 responses)- A16% (4)
- B8% (2)
- C4% (1)
- D72% (18)
Community Discussion
No community discussion yet for this question.