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
What is t-sql? : Transact sql
What are dml commands?
Why do we use subquery?
What is clustered and nonclustered index in sql?
What is embedded sql what are its advantages?
Is join and inner join the same?
What is the difference between execution of triggers and stored procedures?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
If a cursor is open, how can we find in a pl/sql block?
What are the basic techniques of indexing?
How many types of cursors are available in pl/sql?
How do I count duplicates in sql?
what are sequences
What is time based sql injection?
Is full outer join same as cross join?