which will fire first ? Trigger or Constraint

Answer Posted / srikanth k

The sequence of execution is:
1) before statement level
2) before row level
3) constraint
4) after row level
5) after statement level

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is parallel hint?

935


what are all the common sql function? : Sql dba

779


Is record in pl sql?

677


Is sql a scripting language?

690


How to handle bulk data?

1050






How many types of primary keys are there?

710


What are secondary keys?

735


What is an escape character in sql?

743


What is forward declaration in pl sql?

758


What is synchronized subquery?

822


Why do we need unique key in a table?

673


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2189


What is auto increment in sql?

823


how many sql dml commands are supported by 'mysql'? : Sql dba

790


Is coalesce faster than isnull?

702