Microsoft
70-433 · Question #70
70-433 Question #70: Real Exam Question with Answer & Explanation
The correct answer is D. CREATE TRIGGER [uModDate] ON [OrderDetails]. See the full explanation below for the reasoning.
Question
Your database contains two tables named Order and OrderDetails that store order information. They relate to each other using the OrderID column in each table. Your business requires that the LastModifiedDate column in the Order table must reflect the date and time when a change is made in the OrderDetails table for the related order. You need to create a trigger to implement this business requirement. Which Transact-SQL statement should you use?
Options
- ACREATE TRIGGER [uModDate] ON [OrderDetails]
- BCREATE TRIGGER [uModDate] ON [Order]
- CCREATE TRIGGER [uModDate] ON [Order]
- DCREATE TRIGGER [uModDate] ON [OrderDetails]
Community Discussion
No community discussion yet for this question.