Multiple choice technology databases

A Trigger can be for

  1. Stored Procedure

  2. Function

  3. Table

  4. View
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Triggers are primarily associated with tables and execute in response to INSERT, UPDATE, or DELETE operations on that table. While INSTEAD OF triggers can also be created on views, tables are the fundamental object for which triggers are defined.

AI explanation

Table is the expected answer — the classic, most common form of a database trigger is a DML trigger bound to a table, firing on INSERT/UPDATE/DELETE against that table's rows. Stored procedures and functions are called by triggers but aren't themselves trigger targets. Note there's a real-world caveat: many databases (e.g., Oracle) also support INSTEAD OF triggers on views, so 'View' isn't strictly always wrong — but for a basic quiz distinguishing triggers from procedures/functions, Table is the intended and most defensible answer.

Keep practicing — related questions