Answer Posted / anitha
A trigger is a set of actions that are run automatically when a specified change operation is performed on a specified table. The change operation can be an SQL INSERT, UPDATE, or DELETE statement, or an insert, update, or delete high level language statement in an application program
types of triggers.
• Before delete trigger
• Before insert trigger
• Before update trigger
• After delete trigger
• After insert trigger
• After update trigger
• Read only trigger (external trigger only)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the contention situations caused by locks?
Who uses db2?
Explain the contents that are a part of dclgen.
What is lock escalation in db2?
What is page size in db2?
Are view updateable?
What is explain plan in db2?
What is check constraint. Explain with example.
Can one database have multiple instances?
What is cursor with hold option in db2?
What is a trigger in the db2 database?
What is a system catalog table in db2?
What is bind package and plan in db2?
What is release/acquire in bind?
Which isolation level provides maximum concurrency?