SQL Basics Practice Test

Triggers are special stored procedures that automatically execute in response to events on a table, such as inserts, updates, or deletes. They’re defined to fire either before or after the triggering event and can operate for each row or for the whole statement, allowing you to enforce rules, capture audits, or propagate changes automatically. This automatic, event-driven behavior sets triggers apart from other database objects.

Functions are routines you call explicitly to compute and return a value, not something that runs on table events. Views are saved queries that present data; they don’t execute in response to data changes. Procedures are sets of SQL statements you run on demand, not automatically triggered by data modification events.