The          lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.

Related MCQs

• The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
• A(n) ____ lock exists when concurrent transactions are granted Read access on the basis of a common lock.
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• A lock that allows concurrent transactions to access different rows of the same table is known as a
• Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
• The situation where the lock waits only for a specified amount of time for another lock to be released is
• In a ____ lock, the DBMS will lock an entire disk page.
• Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.
• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.