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