What term refers to a special type of stored procedure that executes automatically in response to events and is associated with a specific table?

• A. View
• B. Cursor
• C. Function
• D. Trigger

Answer: (D)

Triggers are special stored procedures that run automatically in response to events on a table, such as inserts, updates, or deletes. They are tied to a specific table and can be set to fire before or after the event, depending on the database system. Triggers let you enforce rules, maintain audit trails, or cascade actions without changing application code, and they can access the old and new values of the affected rows to make decisions. In contrast, a view is simply a saved query representation of data, a cursor is a tool for iterating over result sets, and a function is a reusable block that you call explicitly to obtain a value. This describes a trigger.