Multiple choice technology programming languages

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 database systems, locks can be obtained on tablespaces to manage concurrent access and maintain data integrity. Locking on individual columns is too granular, while bufferpools are memory structures. Directories don't support locking in the same way. Tablespaces are the primary locking granularity in many DBMS like DB2.

Keep practicing — related questions