Which type of trigger is fired for each row of DML operation?

Options
- ROW Trigger
- Statement Trigger
- Combination Trigger
- Before Trigger


CORRECT ANSWER : Statement Trigger

Discussion Board
Statement trigger

A statement trigger is fired once on behalf of the triggering statement, regardless of the number of rows in the table that the triggering statement affects, even if no rows are affected. For example, if a DELETE statement deletes several rows from a table, a statement-level DELETE trigger is fired only once. Statement triggers are useful if the code in the trigger action does not depend on the data provided by the triggering statement or the rows affected. For example, use a statement trigger to:
- Make a complex security check on the current time or user.
- Generate a single audit record.

Prajakta Pandit 02-21-2017 05:33 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement