Podcast
Questions and Answers
On a successful validation, transactions are restarted.
On a successful validation, transactions are restarted.
False (B)
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 (B)
Coarse granularity leads to high concurrency.
Coarse granularity leads to high concurrency.
False (B)
A disk block is an example of fine granularity.
A disk block is an example of fine granularity.
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.
Multiple granularity locking is used to manage a flat hierarchy of granularity.
Multiple granularity locking is used to manage a flat hierarchy of granularity.
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).
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).
The entire database is an example of fine granularity.
The entire database is an example of fine granularity.
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).
