GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Placement Papers  >  IBM  >  Technical
Go To First  |  Previous Question  |  Next Question 
 Technical  |  Question 20 of 98    Print  
What is trigger in DBMS

  
Total Answers and Comments: 5 Last Update: September 12, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 16, 2005 23:03:13   #1  
Kiranmayi        

RE: What is trigger in DBMS
A program in a database that gets called each time a row in a table is INSERTED, UPDATED, or DELETED. Triggers allow you to check that any changes are correct, or to fill in missing information before it is commited. Triggers are normally written in PL/SQL or Java
 
Is this answer useful? Yes | No
September 22, 2005 18:22:47   #2  
veena Member Since: September 2005   Contribution: 2    

RE: What is trigger in DBMS
A Trigger is a PL/SQL block that executes whenever a particular event takes place.events in database like Insert,Update, Delete and combination of these three will cause the trigger to execute.Trigger is a technique to maintain integrity constraints
 
Is this answer useful? Yes | No
September 24, 2005 03:33:16   #3  
Susan        

RE: What is trigger in DBMS
Trigger is an SQL procedure that initates an action when an event(inser/delete/update) occurs. They are stored and manageed by DBMS.A trigger cannot be called or executed:the DBMS automatically fires the trigger as a result of a data modification to the associated table. Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. Each trigger is attached to a single, specific table in the database.
 
Is this answer useful? Yes | No
September 10, 2008 15:44:53   #4  
nikhilbagde Member Since: September 2008   Contribution: 1    

RE: What is trigger in DBMS
PL/SQL programming block that is executed implicity by data manipulation statement and trigger is perform event in database and application level.

Can be either :
Application Trigger : fired whenever an event occurs DML statement with particular application.

Database Trigger : fired whenever a data event (such as DML) or system event (such as logon on and shutdown) occurs on a schema or database

Regards
Nikhil Bagde
any query regarding pl/sql plz send ur que

 
Is this answer useful? Yes | No
September 12, 2008 12:29:50   #5  
yuvrajpape88 Member Since: September 2008   Contribution: 1    

RE: What is trigger in DBMS
A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. Triggers can restrict access to specific data, perform logging, or audit data modifications.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape