Answer Posted / gourvendra singh

This is for the people who says 'No' to the answer no 7.
As i still believe that it totally depends upon the timings of the trigger.
Consider the below example:
Example1: If i created a trigger as Before insert/update/delete on a table. Whenever user will perform any DML operation on the said table, the trigger will always executes first then it will check the constraint.
Example2: If I created a trigger as After Insert/Update/Delete on a table. Whenever user will perform a DML operation on the said table, the constraint will execute first then the trigger will be executed.
Please mail me if I am wrong on the below mail id:
raviindian2114@gmail.com

What is the difference between a database and a relational database?

1034

---

How can you tell the difference between an index and a view?

869

---

what are the join types in tsql? : Transact sql

980

---

Is keyword pl sql?

930

---

Can we rollback after truncate?

979

---

What is the difference between the sql*loader and import utilities? : aql loader

975

---

What is sql*loader?

1071

---

What is sql mysql pl sql oracle?

1025

---

what are date and time intervals? : Sql dba

998

---

What is int identity in sql?

1057

---

Why do we use subquery?

942

---

How delete all data from all tables in sql?

882

---

Differentiate between syntax and runtime errors.

1119

---

Can we insert in view in sql?

1000

---

Explain unique key in sql.

942

---