Answer Posted / nilesh

There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS

Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE

and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)

ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

What is sql keyword?

944

---

What is the syntax and use of the coalesce function?

1097

---

What are the three pl sql block types?

946

---

What are all different types of collation sensitivity?

973

---

What is duration in sql profiler trace?

1020

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

932

---

How does index help in query performance?

967

---

How are functions and procedures called in PL/SQL?

1128

---

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

984

---

What are types of exception?

873

---

How do I install sql?

940

---

Can we use threading in pl/sql?

971

---

What is primary key sql?

951

---

how to analyze tables with 'mysqlcheck'? : Sql dba

958

---

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

976

---