98-364 · Question #54
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…
The correct answer is B. CREATE TRIGGER trgExamQuestionsModified. See the full explanation below for the reasoning.
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
How the community answered
(29 responses)- A3% (1)
- B69% (20)
- C17% (5)
- D10% (3)
Community Discussion
No community discussion yet for this question.