Podcast
Questions and Answers
On a successful validation, transactions are restarted.
On a successful validation, transactions are restarted.
False
The granularity of data items has no effect on concurrency control performance.
The granularity of data items has no effect on concurrency control performance.
False
Coarse granularity leads to high concurrency.
Coarse granularity leads to high concurrency.
False
A disk block is an example of fine granularity.
A disk block is an example of fine granularity.
Signup and view all the answers
Intention-shared locks are used to indicate that an exclusive lock will be requested on some descendent nodes.
Intention-shared locks are used to indicate that an exclusive lock will be requested on some descendent nodes.
Signup and view all the answers
Multiple granularity locking is used to manage a flat hierarchy of granularity.
Multiple granularity locking is used to manage a flat hierarchy of granularity.
Signup and view all the answers
A shared-intention-exclusive lock is used to indicate that the current node is locked in exclusive mode but a shared lock(s) will be requested on some descendent nodes(s).
A shared-intention-exclusive lock is used to indicate that the current node is locked in exclusive mode but a shared lock(s) will be requested on some descendent nodes(s).
Signup and view all the answers
Intention-exclusive locks are used to indicate that a shared lock(s) will be requested on some descendent nodes(s).
Intention-exclusive locks are used to indicate that a shared lock(s) will be requested on some descendent nodes(s).
Signup and view all the answers
The entire database is an example of fine granularity.
The entire database is an example of fine granularity.
Signup and view all the answers
Multiple granularity locking is used to manage a hierarchy of granularity from fine (record) to coarse (database).
Multiple granularity locking is used to manage a hierarchy of granularity from fine (record) to coarse (database).
Signup and view all the answers