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

Why use stored procedures?

762


What is the difference between partitioning and sharding?

715


What is difference between my sql and sql?

707


what are ddl statements in mysql? : Sql dba

762


What is cursor in pl sql with examples?

662






what are sequences

1309


What are the different types of constraints?

734


What is the use of function in sql?

714


Is natural join and inner join same?

648


what are dynamic queries in t-sql? : Transact sql

731


What is cross join sql?

668


What are tables and fields in the database?

740


What are the different ways to optimize a sql query?

667


How to use transactions efficiently : transact sql

757


which operator is used in query for pattern matching? : Sql dba

749