what is a trigger and types of triggers

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.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between nvl and coalesce?

602


Explain the contention situations caused by locks?

592


What is buffer pool?

613


What types of tables are there in the db2 database?

556


What is the function of logging in the db2 database?

645






What is scrollable cursor in db2?

583


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

614


What is dpf in db2?

666


What is isolation level in db2?

577


What is bufferpool in db2?

580


How would the varchar column remarks defined?

636


How to rename a table in DB2 ?

639


How to create db2 table in mainframe?

631


What is db2 purescale?

551


What is ibm db2 used for?

601