Multiple choice technology databases

A plan is a collection of

  1. Binds

  2. DBRMs

  3. Packages

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

In DB2, a plan is an executable entity that contains one or more packages. Packages are the building blocks that contain the executable SQL statements and access paths. When you bind a plan, you're essentially organizing related packages together for execution. Binds (A) are the process of creating plans/packages, DBRMs (B) are database request modules containing SQL statements, and Collections (D) are logical groupings but not what plans directly contain. The plan-to-package relationship is fundamental to DB2's application management architecture.

Keep practicing — related questions