What is a database trigger?



What is a database trigger?..

Answer / Deepak Kumar Swarooop

A database trigger is a piece of PL/SQL code that automatically executes in response to certain events such as insert, update, delete, or DDL (Data Definition Language) statements. Triggers are used to maintain data integrity and enforcing business rules.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How do you define a foreign key?

1 Answers  


how to analyze tables with 'mysqlcheck'? : Sql dba

1 Answers  


How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,


what is data integrity

3 Answers   Fidelity, TCS,


What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,


Does a join table need a primary key?

1 Answers  


what is rdbms? : Sql dba

1 Answers  


What is on delete restrict?

1 Answers  


what is the stuff function and how does it differ from the replace function? : Sql dba

1 Answers  


What is rtm stands for?

1 Answers  


What is bind reference and how can it be created?

1 Answers  


how to sort records in sql?

3 Answers  


Categories