Microsoft
70-432 · Question #120
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…
The correct answer is A. You should develop a trigger which rolls back changes to the Price column which breaks. See the full explanation below for the reasoning.
Question
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?
Options
- AYou should develop a trigger which rolls back changes to the Price column which breaks
- BOn the Price column, you should develop a primary key constraint to a table which includes
- CYou should develop a view which rolls back changes to the Price column which breaks
- DYou should develop a stored procedure which allows changes to the Price column which
How the community answered
(21 responses)- A71% (15)
- B5% (1)
- C5% (1)
- D19% (4)
Community Discussion
No community discussion yet for this question.