Question 16 : 70-464 SQL Server 2012 | Free practice exams

Question 16

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?

INSTEAD OF triggers fire in place of the triggering action and before constraints are processed

All of these

If the constraints are violated, the AFTER trigger is not executed.

If there are AFTER triggers on the table, they will fire after constraint processing.

This is a sample question. You can start the practice exam by clicking the 'Start Practice Exam' link on the exam page.

Back to practice exam

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