Multiple choice technology databases

Which of the following DB2 objects is NOT considered executable using SQL?

  1. Routine

  2. Function

  3. Procedure

  4. Trigger
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DB2 distinguishes between executable objects and event-driven objects. Routines, functions, and procedures are all executable using SQL statements like CALL or SELECT. However, triggers are not directly executed - they are defined to fire automatically when specific events (INSERT, UPDATE, DELETE) occur on a table. You cannot explicitly invoke a trigger with a SQL statement; it responds to data modification events. This is a fundamental architectural difference in how these objects operate.

Keep practicing — related questions