70-433 · Question #70
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…
Sign in or unlock 70-433 to reveal the answer and full explanation for question #70. The question stem and answer options stay visible for context.
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]
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.