Multiple choice technology databases

Which of the following DB2 objects can be referenced by an INSERT statement to generate values for a column?

  1. Identity column

  2. Table function

  3. Sequence

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

Sequences in DB2 are explicitly referenced in INSERT statements using expressions like NEXT VALUE FOR sequence_name or PREVIOUS VALUE FOR sequence_name to generate unique numeric values for a column. Identity columns are implicitly auto-generated and not externally referenced. Table functions return row sets, not single values. Triggers execute code but don't generate values directly for INSERT.

Keep practicing — related questions