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.
Loading...
Related Quiz
- In disaster recovery planning, what does the term "RPO" stand for?
- What is the primary purpose of XML and JSON support in DB2?
- Which SQL statement is used to declare a cursor in DB2?
- Scenario: During a routine check, the Health Monitor detects a deviation from compliance standards. What measures should the administrator implement to address this deviation and prevent future occurrences?
- What is dynamic SQL statement caching in DB2, and how does it enhance security?