AVA Consultancy Services Interview Questions and Answers

SQL triggers are special stored procedures that are automatically executed when certain events occur in a database.

• Triggers are used to enforce business rules, maintain referential integrity, and automate repetitive tasks.

• They can be defined to execute before or after INSERT, UPDATE, or DELETE operations on a table.

• For example, a trigger can be created to update a log table whenever a new record is inserted into a main

SQL functions and triggers are used to perform specific tasks within a database.

• Functions in SQL are reusable blocks of code that can accept input parameters and return a value.

• Triggers in SQL are special types of stored procedures that are automatically executed in response to certain events on a table.

• Functions can be used to perform calculations, manipulate data, or return specific values.

• Triggers can be used to enf...read more