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.

Can a table contain multiple primary key’s?

1155

---

What is sql and how does it work?

1248

---

What is over () in sql?

1012

---

What are system versioned tables?

1074

---

Why do we use procedures in pl sql?

1073

---

Can a foreign key be null?

1142

---

Which is faster count (*) or count 1?

1088

---

Where is sql database stored?

1038

---

Is nosql relational?

999

---

what are wild cards used in database for pattern matching ? : Sql dba

1204

---

Explain some predefined exceptions.

1091

---

what is the difference between truncate and drop statements? : Sql dba

1179

---

How do I start sql profiler?

1047

---

What are the two types of exceptions in pl/sql?

1090

---

What is the best partition size for windows 10?

1049

---