Machine-translated by Google. Questions are authored in English.
Top

Discussion

A lock that allows concurrent transactions to access different rows of the same table is known as a

  • A.Field-level lock
  • B.Row-level lock
  • C.Table-level lock
  • D.Database-level lock

Answer: A

Correct answer: Row-level lock

A row-level lock locks only the row being changed, so other transactions may work on different rows of the same table at the same time. It gives the most concurrency of the common granularities, at the cost of more locks to manage; a table-level lock would block the whole table.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.