To work with data, a DBMS must retrieve the data from _____ and place them in _____.
A) data files; procedure cache
B) RAM; data cache
C) permanent storage; RAM
D) temporary files; procedure cache

Question

Quizplus · Accepted Answer

A DBMS must retrieve data from permanent storage (such as hard drive or SSD) and place them in RAM to be accessed and processed efficiently. Data files and temporary files may be used in the process, but the main source and destination of data are permanent storage and RAM respectively. Procedure cache is a memory reserved for storing frequently used code sections (procedures) to speed up query processing, but it is not directly related to data retrieval and placement. Similarly, data cache is a part of RAM used for storing frequently accessed data to reduce disk I/O, but it is not the primary destination for all data in a DBMS.

To Work with Data, a DBMS Must Retrieve the Data