which will fire first ? Trigger or Constraint

Answer Posted / raj dhar

It is depend upon the condition, as if trigger is written
on after insert and update then constraint will fire first
and if you make a trigger as on before insert or update
then the trigger will fire first.

Is This Answer Correct ?    4 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by query optimization?

556


Name three sql operations that perform a sort.

600


How is a process of pl/sql compiled?

612


What is query optimization in sql?

556


What is sql character function?

550






What is integrity in sql?

570


What do you mean by field in sql?

546


what tools available for managing mysql server? : Sql dba

545


What are literals in sql server?

549


how to check myisam tables for errors? : Sql dba

621


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

585


What is the purpose of primary key?

541


When can we use the where clause and the having clause?

588


What is a design view?

533


What is the use of & in pl sql?

544