What is a database trigger ? Name some usages of database trigger ?

 Database  trigger  is stored PL/SQL program unit associated with a specific database   table.   Usages   are  Audit  data  modifications,  Log  events transparently,   Enforce   complex  business  rules  Derive  column  values automatically,   Implement   complex    security  authorizations.  Maintain replicate tables.
  • Interview Candidate
  • 7
  • 6664

Showing Answers 1 - 7 of 7 Answers

tm1966_muthu

  • Feb 17th, 2006
 

A database trigger is a stored procedure that is invoked automatically when a predefined event occurs.

Database triggers enable DBA's (Data Base Administrators) to create additional relationships between separate databases.

For example, the modification of a record in one database could trigger the modification of a record in a second database.

krishnaindia2007

  • May 6th, 2008
 

A database trigger is a named pl/sql block associated with a table and fires automatically when an event occurs or something happens.

 Data auditing , Implementing complex business rules, security are main uses of database triggers.

KSPRADEEP

  • Oct 17th, 2012
 

Trigger is data base object .Trigger is block of code it is executed automatically when dml operations are fired .

by using trigger we can do the auditing and perform a operation(modifications) on a tables (using dml operation)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions