which will default fire first 
statement level trigger or row level trigger

Answers were Sorted based on User's Feedback



which will default fire first  statement level trigger or row level trigger..

Answer / vijay

Statement level trigger is default trigger

Is This Answer Correct ?    15 Yes 0 No

which will default fire first  statement level trigger or row level trigger..

Answer / ram

Before Insert/update/delete triggers executes first..
In this statement level triggers execute first..the order flows as below
Statement level -- before trigger
row level -- before trigger
row level -- after Insert/update/delete triggers
statement level -- after Insert/update/delete triggers

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,


Why left join is used in sql?

0 Answers  


Which normal form is best?

0 Answers  


Types of optimization?

6 Answers   Microsoft,


Explain some predefined exceptions.

0 Answers  






Why join is faster than subquery?

0 Answers  


What is sql entity?

0 Answers  


what are tables and fields? : Sql dba

0 Answers  


define sql update statement ? : Sql dba

0 Answers  


What is write ahead logging in sql server?

0 Answers  


what is meant by forward declaration in functions?

4 Answers   TCS,


What are the dml statements?

0 Answers  


Categories