Answer Posted / anilbabu makkena

It is on the based situation.
1st situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER Created.

1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fires.

2nd situation CONSTRAINT and AFTER STATEMENT Level TRIGGER
and AFTER ROW Level TRIGGER Created.

1.CONSTRAINT fires.
2.AFTER ROW Level TRIGGER Fires.
3.AFTER STATEMENT Level TRIGGER Fires.

3rd situation CONSTRAINT and BEFORE STATEMENT Level TRIGGER
and BEFORE ROW Level TRIGGER and AFTER ROW Level TRIGGER and
AFTER STATEMENT Level TRIGGER Created.

1.BEFORE STATEMENT Level TRIGGER Fires.
2.BEFORE ROW Level TRIGGER Fires.
3.CONSTRAINT Fire.
4.AFTER ROW Level TRIGGER Fires.
5.AFTER STATEMENT Level TRIGGER Fires.

What is a dynamic query?

1022

---

Does inner join return duplicate rows?

976

---

What is a rank in sql?

963

---

What is rename in sql?

972

---

Why select is used in sql?

1018

---

What is faster join or subquery?

1011

---

How do I partition a table in sql?

1129

---

What is trigger and how to use it in sql?

1021

---

Does sql backup shrink transaction log?

978

---

What will you get by the cursor attribute sql%rowcount?

1037

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1059

---

What is the difference between function and procedure in pl/sql?

1082

---

what are the different tables present in mysql? : Sql dba

984

---

What are the advantages of stored procedure?

1003

---

Which nosql database is best?

975

---