Microsoft
98-364 · Question #54
98-364 Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock 98-364 to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
Question
You are a database developer for a database named Sales hosted on a SQL Server 2008 server. The Sales database includes the Exams and ExamQuestions tables. If any questions are modified for an exam, you need to ensure that the ExamModifiedDate in the Exams table is updated with the date and time of the update. The ExamQuestions table includes an INSTEAD OF trigger that records when and who last modified each question. Therefore, you decide to create a trigger. You only want the trigger to fire if a constraint violation has not occurred. Which of the following code will create the trigger to meet your goals?
Options
- ACREATE TRIGGER trgExamQuestionsModified
- BCREATE TRIGGER trgExamQuestionsModified
- CCREATE TRIGGER trgExamQuestionsModified
- DCREATE TRIGGER trgExamQuestionsModified
Unlock 98-364 to see the answer
You've previewed enough free 98-364 questions. Unlock 98-364 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.