Free Practice Exam -
70-461 - SQL Server 2012
Question 1 of 15
A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server. DML events include UPDATE, INSERT, or DELETE statements issued against a table or view. Which of the following is TRUE regarding INSTEAD OF triggers?
All of these
INSTEAD OF triggers fire in place of the triggering action and before constraints are processed
If there are AFTER triggers on the table, they will fire after constraint processing.
If the constraints are violated, the AFTER trigger is not executed.
That was the correct answer, well done!
Sorry, that was the wrong answer
Exam Progress
Move on to the next question
Home
Microsoft Exams
Free practice exams are provided free of charge by Accelerated Ideas. Please respect our exams and do not reproduce our material or abuse the testing system. Thank you. Microsoft exams for MCPD, MCTS, MCP, MCSE, MCSA, MCAD, MCSD
Home
Copyright © Accelerated Ideas 2005-2019
All rights reserved