How many types of database triggers can be specified on a table ? What are they

How many types of database triggers can be specified on a
table ? What are they ?

Question Posted / guest

2 Answers
12766 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many types of database triggers can be specified on a table ? What are they ?..

Answer / 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.)

Is This Answer Correct ?

17 Yes

4 No

How many types of database triggers can be specified on a table ? What are they ?..

Answer / biswajit biswal

We can specified 28 Database triggers on a single table.

Before Row level insert
After Statement level update
Delete
insert or update
update or delete
insert or delete
insert or update or delete

2*2*7=28

Is This Answer Correct ?

1 Yes

6 No

Post New Answer