Question

SQL triggers can be used with which SQL operations?

1) INSERT
2) UPDATE
3) DELETE
4) All of the above

Answer 1

SQL triggers can be associated with INSERT, UPDATE, and DELETE operations, making 'All of the above' the correct answer. Triggers help with data integrity, business rules enforcement, and maintaining an audit trail.

Step-by-step explanation:

SQL triggers can be used with a variety of SQL operations. Specifically, triggers are designed to automatically execute or fire a predefined action when certain events occur within the database. The events that can prompt a trigger include:

1. INSERT operations, which add new rows to a table.
2. UPDATE operations, which modify existing rows in a table.
3. DELETE operations, which remove existing rows from a table.

Therefore, the answer is 4) All of the above. Triggers can be incredibly useful for maintaining data integrity, enforcing business rules, and keeping an audit trail of changes within a database.