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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is not equal in sql?

759


Is there a 64 bit version of ssms?

717


What is cte?

772


Can you rollback after commit?

755


Define concurrency control. : Transact sql

860


what are the advantages of using stored procedures? : Sql dba

862


How do you modify a column in sql?

773


What is normalization sql?

782


Is it mandatory for the primary key to be given a value when a new record is inserted?

967


How to rename a column in the output of sql query?

778


What is mutating sql table?

863


Why is stored procedure faster than query?

758


What are %type and %rowtype for?

850


How do you respond to dementia behavior?

765


How many times can we commit in a loop?

780