Multiple choice technology databases

Which of the following objects contains control structures that are considered the bound form of SQL statements

  1. UDT

  2. Trigger

  3. Package

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

A Package in DB2 contains the bound form of SQL statements. When SQL statements are prepared and bound, they are stored in a package object, which includes control structures and the access plan. UDTs are user-defined types, Triggers are event-driven actions, and Access plans are execution plans, but only Packages serve as containers for bound SQL control structures.

Keep practicing — related questions