Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A university stores its students relation as heap file in 111 pages. The DBMS that the university uses has a total of 110 buffer
A university stores its students relation as heap file in 111 pages. The DBMS that the university uses has a total of 110 buffer pages and all buffer pages are initially empty. Consider the following query: SELECT FROM Student; which is executed frequently by the administrator and this is the only query that is executed in the DBMS. * a. (5 Points) Between LRU and MRU, which replacement policy should be used by the DBMS in order to minimize the number of I/Os? Explain why. b. (5 Points) Should the database administrator creates an index to speed up the query execution? If yes, which index structure should be used and why? If no, why not?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
a Between LRU Least Recently Used and MRU Most Recently Used replacement policies the DBMS should us...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started