What are the types of triggers ?

Answers were Sorted based on User's Feedback



What are the types of triggers ?..

Answer / manikandan

1)database trigger
2)application trigger

Is This Answer Correct ?    0 Yes 2 No

What are the types of triggers ?..

Answer / sam katwal

There are three types of Triggers
Insert Trigger
Update Trigger
Delete Trigger
One Trigger also exists
Instead of Trigger which was introducted in SQL Server 2000

Is This Answer Correct ?    21 Yes 24 No

What are the types of triggers ?..

Answer / ramprakash

Instead of Triggers
After Triggers

Is This Answer Correct ?    15 Yes 18 No

What are the types of triggers ?..

Answer / sandeep chawdekar

there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger

dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing

instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs

system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level

Is This Answer Correct ?    0 Yes 4 No

What are the types of triggers ?..

Answer / anandkumar

DDL and DML Triggers

Is This Answer Correct ?    13 Yes 20 No

What are the types of triggers ?..

Answer / arjun singh

INSERT TRIGGER
UPDATE TRIGGER
DELETE TRIGGER

Is This Answer Correct ?    7 Yes 22 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  


Types of cursor locks and explanation each of them ?

3 Answers   DELL, HP Finsoft,


Is nosql faster than sql?

0 Answers  


what is Complex index. how to create it?

2 Answers  


What is a relationship and what are they?

0 Answers  






Explain ttitle and btitle.

0 Answers  


What is forward declaration in pl sql?

0 Answers  


What is the location of pre_defined_functions.

0 Answers  


What is difference between sql function and stored procedure?

0 Answers  


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

2 Answers  


How many types of literals are available in pl sql?

0 Answers  


How many types of keys are there in sql?

0 Answers  


Categories