Answer Posted / kaushik

If Trigger is written on the table for before insert on
each row then
Trigger will fire first
else
Constraints will fire first.

Vijay Kumar is perfectly right.

Is delete faster than truncate?

755

---

how to get @@error and @@rowcount at the same time? : Sql dba

745

---

Why functions are used in sql?

706

---

What is trigger point?

732

---

Is merge a dml statement?

731

---

---

What are the types of join and explain each?

778

---

What are local and global variables and their differences?

810

---

What is materialized view. What are different methods of refresh?

1070

---

What is online transaction processing (oltp)?

749

---

What are the different set operators available in sql?

758

---

What are the different types of a subquery?

715

---

What is data control language?

736

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

878

---

What program will open a mdb file?

684

---

How can you select unique records from a table?

701

---