Complete the code to identify the main purpose of buffer management in a DBMS.
Buffer management is responsible for [1] data between disk and main memory.
Buffer management handles transferring data between disk storage and main memory to improve access speed.
Complete the code to describe the buffer pool in DBMS.
The buffer pool is a [1] area in main memory that stores pages read from disk.
The buffer pool is a temporary memory area used to hold disk pages for quick access.
Fix the error in the statement about page replacement policy.
The [1] policy removes the page that has been used most recently.MRU (Most Recently Used) policy removes the page used most recently, unlike LRU which removes the least recently used.
Fill both blanks to complete the buffer replacement condition.
A page is replaced if it is [1] and [2] in the buffer pool.
Pages that are unreferenced and clean (not modified) are good candidates for replacement.
Fill all three blanks to complete the buffer management dictionary comprehension.
buffer_dict = {{ [1]: [2] for page, status in pages.items() if status [3] 'clean' }}This comprehension creates a dictionary of pages with their status only if the status is 'clean'.