Home »
MCQs »
DBMS MCQs
DBMS Buffer Replacement Strategies MCQs
DBMS Buffer Replacement Strategies MCQs: This section contains multiple-choice questions and answers on Buffer Replacement Strategies in DBMS.
Submitted by Anushree Goswami, on May 06, 2022
1. During buffer replacement, existing blocks are replaced with the ___ blocks in the buffer.
- Old
- New
- Same
- None
Answer: B) New
Explanation:
During buffer replacement, existing blocks are replaced with the new blocks in the buffer.
2. How many strategies does Buffer Manager use for Buffer Replacement?
- 2
- 3
- 4
- 5
Answer: B) 3
Explanation:
There are 3 strategies does Buffer Manager used for Buffer Replacement.
3. Which of the following does the Buffer Manager use for Buffer Replacement?
- Least Recently Used Strategy
- Toss-Immediate Strategy
- Most-Recently Used Strategy
- All of the above
Answer: D) All of the above
Explanation:
The Buffer Manager uses the following strategies for Buffer Replacement -
- Least Recently Used Strategy
- Toss-Immediate Strategy
- Most-Recently Used Strategy
4. Data or processes with the ____ score in their most recent use is replaced with the new data or processes.
- Highest
- Lowest
- Average
- None
Answer: B) Lowest
Explanation:
Data or processes with the lowest score in their most recent use are replaced with the new data or processes.
5. ____-replacement strategy replaces the most recently referenced ____ if an existing ____ needs to be replaced.
- Buffer
- Block
- Both A and B
- None of the above
Answer: B) Block
Explanation:
Block-replacement strategy replaces the most recently referenced block if an existing block needs to be replaced.
6. In the _____ strategy, the buffer manager should be instructed before processing of the final result, when the space occupied by a specific block is freed.
- Least-used
- Toss-immediate
- Most-used
- None
Answer: B) Toss-immediate
Explanation:
In the toss-immediate strategy, the buffer manager should be instructed before processing of the final result, when the space occupied by a specific block is freed.
7. ____ replaces recent data or processes with the existing ones with the data or processes with the highest scores.
- LRU
- TI
- MRU
- None
Answer: C) MRU
Explanation:
MRU replaces recent data or processes with the existing ones with the data or processes with the highest scores.
8. The choice of the appropriate strategy is also affected by ___.
- Data
- Time
- Money
- Choice
Answer: B) Time
Explanation:
The choice of the appropriate strategy is also affected by time.
9. Database systems may have to delay some requests if they receive ____ requests from different users, so they can preserve data consistency.
- Consecutive
- Simultaneous
- Concurrent
- None
Answer: C) Concurrent
Explanation:
Database systems may have to delay some requests if they receive concurrent requests from different users, so they can preserve data consistency.
10. The buffer manager may ___ its strategies if it learns about the delayed requests.
- Update
- Modify
- Add
- Delete
Answer: B) Modify
Explanation:
The buffer manager may modify its strategies if it learns about the delayed requests.
ADVERTISEMENT
ADVERTISEMENT