Multiple choice technology mainframe

identify which one is correct?

  1. plan is obtained by binding DBRMs into packages

  2. plan is executable as it contains the acess path

  3. it is advantageous to use packages because it reduces the cost of bind

  4. All of the above

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In DB2, packages are created by binding DBRMs, and plans are executable structures containing access paths. Using packages reduces bind costs because only modified packages need rebinding. Thus, all statements are correct.