Home »
MCQs »
DBMS MCQs
DBMS Multiple Granularity MCQs
DBMS Multiple Granularity MCQs: This section contains multiple-choice questions and answers on Multiple Granularity in DBMS.
Submitted by Anushree Goswami, on April 21, 2022
1. Data items may be ___ based on their granularity.
- Opened
- Locked
- Added
- Closed
Answer: B) Locked
Explanation:
Data items may be locked based on their granularity.
Discuss this Question
2. Hierarchically creating lockable blocks within the database can be described as hierarchically ___ it up.
- Creating
- Breaking
- Locking
- Adding
Answer: B) Breaking
Explanation:
Hierarchically creating lockable blocks within the database can be described as hierarchically breaking it up.
Discuss this Question
3. ___ are reduced by using Multiple Granularity protocols.
- Concurrency
- Lock Overhead
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Concurrency and lock overhead are reduced by using Multiple Granularity protocols.
Discuss this Question
4. What is TRUE about Multiple Granularity?
- It keeps track of what should be locked and how.
- Data items can be locked and unlocked easily with this software.
- A tree can be used to represent this type of hierarchy graphically.
- All of the above
Answer: D) All of the above
Explanation:
In case of Multiple Granularity -
- It keeps track of what should be locked and how.
- Data items can be locked and unlocked easily with this software.
- A tree can be used to represent this type of hierarchy graphically.
Discuss this Question
5. How many additional lock modes are there with Multiple Granularity?
- 3
- 4
- 5
- 6
Answer: A) 3
Explanation:
There are 3 additional lock modes in Multiple Granularity.
Discuss this Question
6. Which of the following is the additional lock mode?
- Intention-shared
- Intention-exclusive
- Shared & Intention-exclusive
- All of the above
Answer: D) All of the above
Explanation:
The additional lock modes are -
- Intention-shared
- Intention-exclusive
- Shared & Intention-exclusive
Discuss this Question
7. What is the short form of Intention-shared?
- IS
- IX
- SIX
- None
Answer: A) IS
Explanation:
Short form of Intention-shared is IS.
Discuss this Question
8. Locking explicitly at lower levels of the tree is included in intention-shared, but only for ___ locks.
- Unique
- Multiple
- Two
- Shared
Answer: D) Shared
Explanation:
Locking explicitly at lower levels of the tree is included in intention-shared, but only for shared locks.
Discuss this Question
9. What is the short form of Intention-exclusive?
- IS
- IX
- SIX
- None
Answer: B) IX
Explanation:
Short form of Intention-exclusive is IX.
Discuss this Question
10. ___ locks are used in intention-exclusive locking at the lower level.
- Exclusive
- Shared
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Exclusive or shared locks are used in intention-exclusive locking at the lower level.
Discuss this Question
11. What is the short form of Shared & Intention-exclusive?
- SIE
- S&IE
- SAIE
- SIX
Answer: D) SIX
Explanation:
Short form of Shared & Intention-exclusive is SIX.
Discuss this Question
12. In a ___, some nodes are locked in exclusive mode by the same transaction while others are locked in shared mode.
- IS Lock
- IX Lock
- SIX Lock
- None
Answer: C) SIX Lock
Explanation:
In a SIX lock, some nodes are locked in exclusive mode by the same transaction while others are locked in shared mode.
Discuss this Question
13. What does compatibility matrix use to ensure serializability?
- Shared lock
- Intention lock
- Shared & Intention lock
- None of the above
Answer: B) Intention lock
Explanation:
Compatibility matrix uses intention lock to ensure serializability.
Discuss this Question
14. The protocol requires a node to follow which protocol(s) when attempting to lock a node?
- The lock-compatibility matrix should be followed for transactions.
- The first transaction in the tree locks the root.
- In any mode, the root can be locked.
- All of the above
Answer: D) All of the above
Explanation:
The protocol requires a node to follow these protocols when attempting to lock a node:
- The lock-compatibility matrix should be followed for transactions.
- The first transaction in the tree locks the root.
- In any mode, the root can be locked.
Discuss this Question
15. Nodes in S or IS modes will only be locked if the transaction's parent is locked in ___ mode.
- IS
- IX
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Nodes in S or IS modes will only be locked if the transaction's parent is locked in either IX or IS mode.
Discuss this Question
16. The transaction will lock a node in ___ mode only if the parent of the node is locked in IX or SIX.
- X
- SIX
- IX
- All of the above
Answer: D) All of the above
Explanation:
The transaction will lock a node in X, SIX, or IX mode only if the parent of the node is locked in IX or SIX.
Discuss this Question
17. The Transaction can lock a node if it has ____.
- Locked one node yet
- Locked two nodes yet
- Not locked any nodes yet
- Locked multiple nodes yet
Answer: C) Not locked any nodes yet
Explanation:
The Transaction can lock a node if it has not unlocked any nodes yet.
Discuss this Question
18. A transaction that currently has ___ children of the locked node will unlock the node if none are locked currently.
- One
- Two
- Multiple
- No
Answer: D) No
Explanation:
A transaction that currently has no children of the locked node will unlock the node if none are locked currently.
Discuss this Question
19. In multiple-granularity, locks are acquired ___ and locked down ¬___, respectively.
- Top-down, Bottom-up
- Bottom-up, Top-down
- Top-down
- Bottom-up
Answer: A) Top-down, Bottom-up
Explanation:
In multiple-granularity, locks are acquired top-down and locked down bottom-up, respectively.
Discuss this Question