Podcast
Questions and Answers
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?
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?
Which type of lock has only two states: locked (1) or unlocked (0)?
Which type of lock has only two states: locked (1) or unlocked (0)?
Which type of lock specifically reserves access for the transaction that locked the object?
Which type of lock specifically reserves access for the transaction that locked the object?
Which type of lock allows concurrent transactions to be granted Read access on the basis of a common lock?
Which type of lock allows concurrent transactions to be granted Read access on the basis of a common lock?
Signup and view all the answers
Which locking level locks the entire disk page?
Which locking level locks the entire disk page?
Signup and view all the answers
