Multiple choice technology mainframe

Opens all tablespaces and acquires all tablespace locks when the plan is allocated

  1. ACQUIRE(USE)

  2. ACQUIRE(ALLOCATE)

  3. RELEASE(COMMIT)

  4. RELEASE(DEALLOCATE)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ACQUIRE(ALLOCATE) is the DB2 bind option that opens all tablespaces and acquires all tablespace locks when the plan is allocated (at allocation time). ACQUIRE(USE) would acquire locks only when needed, and RELEASE options control when locks are released, not when they're acquired.

Keep practicing — related questions