Multiple choice technology databases

What will the FREE command do to a plan

  1. It will drop the existing plan

  2. It will delete the existing plan

  3. Both a & b

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The FREE command in DB2 removes (drops/deletes) an existing plan from the system. Once freed, the plan is no longer available and must be rebound if needed again. The terms drop and delete are effectively equivalent in this context.

Keep practicing — related questions