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?

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 2242 | Points: 40
Select from following answers:
  1. All of these
  2. INSTEAD OF triggers fire in place of the triggering action and before constraints are processed
  3. If there are AFTER triggers on the table, they will fire after constraint processing
  4. If the constraints are violated, the AFTER trigger is not executed.
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response