Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is a trigger and types of triggers

Answers were Sorted based on User's Feedback



what is a trigger and types of triggers..

Answer / satty

trigger is a set of actions that will be executed or implemented , when a defined event occur. triggering events are 1.insert, 2.update, 3.delete
triggers can be defined for a specific table and once defined then it is automatically active.
triggers are used to do a data validation and to maintain data integrity.
types of triggers:
before trigger and an after trigger.
triggers information can be stored in the sysibm.systriggers

Is This Answer Correct ?    7 Yes 0 No

what is a trigger and types of triggers..

Answer / 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

what is a trigger and types of triggers..

Answer / 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

More DB2 Interview Questions

what is the difference between join and union?

4 Answers   IBM,


how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,


what is the use of cursors?

3 Answers   iGate,


Can we update view in db2?

0 Answers  


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


what is a collection?

2 Answers  


Is there any advantage to denormalizing DB2 tables?

1 Answers  


Which transaction use a command thread ?

1 Answers  


A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?

7 Answers   IBM,


is it possible to get -811 error when you use cursors. why?

2 Answers   IBM,


Before you give the explain statement, what are the prerogatives?

0 Answers  


db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

1 Answers  


Categories