Multiple choice technology databases

To which of the following resources can a lock NOT be applied?

  1. Tablespaces

  2. Buffer pools

  3. Tables

  4. Rows
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DB2 locking mechanisms can lock tables, rows, and other database objects at various granularities. Buffer pools are memory cache areas used for data page storage and are not database objects that can be locked - locking applies to logical data structures (tables, rows), not memory management structures.

Keep practicing — related questions