Row-level locking in DB2 provides ________ granularity for locking compared to table-level locking.

  • Coarser
  • Finer
  • No locking
  • Similar
Row-level locking in DB2 provides finer granularity for locking compared to table-level locking. With row-level locking, only the specific rows that are being modified are locked, allowing other transactions to access and modify different rows concurrently. This reduces contention and improves concurrency in the database. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *