Statement executed automatically by the system as a side effect of modification to database - Trigger

Q.  A trigger is ?
- Published on 25 Jun 15

a. A statement that enables to start any DBMS
b. A statement that is executed by the user when debugging an application program
c. A condition the system tests for the validity of the database user
d. A statement that is executed automatically by the system as a side effect of modification to the database

ANSWER: A statement that is executed automatically by the system as a side effect of modification to the database
 
A database trigger is what is executed automatically in response to certain events on a particular table or view in a database. It is mostly used to maintain the integrity of the database.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)