5 Questions
Which level of lock allows concurrent transactions to access different rows of the same table, even if the rows are located on the same page?
Row-level lock
Which type of lock has only two states: locked (1) or unlocked (0)?
Binary lock
Which type of lock specifically reserves access for the transaction that locked the object?
Exclusive lock
Which type of lock allows concurrent transactions to be granted Read access on the basis of a common lock?
Shared lock
Which locking level locks the entire disk page?
Page-level lock
Test your knowledge on lock granularity and the different levels at which locking can take place in a database. Learn about database-level locks, table-level locks, page-level locks, row-level locks, and field-level locks.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
