Which of the following describes a lock that allows concurrent transactions to access different records of the same table?

Question

Options

• APage-level lock
• BTable-level lock
• CRow-level lock
• DDatabase-level lock

• A
  14% (7)
• B
  4% (2)
• C
  76% (37)
• D
  6% (3)

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."

No community discussion yet for this question.