DS0-001 · Question #123
DS0-001 Question #123: Real Exam Question with Answer & Explanation
The correct answer is C: Row-level lock. Row-level locking (C) grants locks on individual rows, so multiple transactions can simultaneously read or write different rows in the same table without blocking each other - enabling maximum concurrency. A table-level lock (B) blocks the entire table, preventing any concurrent
Question
Which of the following describes a lock that allows concurrent transactions to access different records of the same table?
Options
- APage-level lock
- BTable-level lock
- CRow-level lock
- DDatabase-level lock
Explanation
Row-level locking (C) grants locks on individual rows, so multiple transactions can simultaneously read or write different rows in the same table without blocking each other - enabling maximum concurrency. A table-level lock (B) blocks the entire table, preventing any concurrent access to any record. A page-level lock (A) locks a fixed-size disk page containing multiple rows, blocking concurrent access to all rows on that page even if transactions need different ones. A database-level lock (D) is the coarsest granularity, locking the entire database and making concurrent multi-user access nearly impossible.
Memory tip: Think of granularity as a zoom level - Row < Page < Table < Database. The finer the lock, the more concurrency you get. "Row-level = row-by-row independence."
Community Discussion
No community discussion yet for this question.