Microsoft
70-457 · Question #26
70-457 Question #26: Real Exam Question with Answer & Explanation
The correct answer is D. CREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS. See the full explanation below for the reasoning.
Question
You develop a Microsoft SQL Server 2012 database that contains a table named Products. The Products table has the following definition: You need to create an audit record only when either the RetailPrice or WholeSalePrice column is updated. Which Transact-SQL query should you use?
Exhibit
Options
- ACREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS
- BCREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS
- CCREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS
- DCREATE TRIGGER TrgPriceChange ON Products FOR UPDATE AS
Community Discussion
No community discussion yet for this question.