Answer Posted / mohit tyagi(siyana bulandshaha

Basically there are three types of triggers, but the way to
use is differ. it doesn't matter on which we are
implementing these trigger.
triggers are:-
1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

we can implement all these trigger on both module i.e
1.Application
2.Database

these both module are associate with the type of
implementation i.e.
1. Insert/delete/update
2. Before/After
3. Statement level/Row level

except this theory there are various ways to represent the
sql trigger. but all have the same concept for
implementation. so never confuse in order to represent the
sql trigger.

What is sql key?

917

---

Enlist some predefined exceptions?

994

---

How can I delete duplicate rows?

963

---

What is normalisation in sql?

1002

---

what are set operators in sql? : Sql dba

982

---

How do you create a unique index?

988

---

Mention what are the benefits of pl/sql packages?

1000

---

How you improve the performance of sql*loader? : aql loader

954

---

Can unique keys be null?

850

---

How do I run sql?

1092

---

What are the parameter modes supported by pl/sql?

1019

---

What is a rank in sql?

897

---

What is normalization in sql?

962

---

Why does sql need a server?

988

---

What is keys and its types?

1019

---