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

How many types of functions are there in sql?

699


How do you create a unique index?

796


Is null operator in sql?

810


What is materialized view in sql?

681


Is pl sql still used?

712


What is the maximum database size for sql express?

769


how to include numeric values in sql statements? : Sql dba

801


how do you know the version of your mysql server? : Sql dba

712


Can we use threading in pl/sql?

736


what are tables and fields? : Sql dba

802


Why we use stored procedure instead of query?

751


What are the advantages of indexing?

761


How to use boolean type in select statement?

773


How many triggers can be applied on a table?

696


Does sap use sql?

735