GEP interview question

Explain triggers in SQL transaction?

Interview Answer

Anonymous

Feb 17, 2026

A trigger is a special stored procedure in SQL that automatically executes when a specific event occurs in a database. - Events include INSERT, UPDATE, or DELETE operations on a table. - They are used to: - Enforce business rules - Maintain data integrity - Track changes (auditing) - Automate tasks without manual intervention