Multiple choice technology databases

For which database object can a lock be obtained

  1. a database directory

  2. a database tablespace

  3. a database bufferpool

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

In DB2, locks can be obtained at the tablespace level, which is a logical grouping of tables. Locking at the tablespace level provides concurrency control for data managed within that tablespace. Options like directory, bufferpool, and column are not lockable objects in DB2.

Keep practicing — related questions