Working with data in the data cache is many times faster than working with data in the data files because ____.
A)there is no network access involved
B)the DBMS doesn't have to wait for the hard disk to retrieve the data
C)the DBMS can optimize queries against the cache
D)the data cache contains only a few records from each table

Question

Quizplus · Accepted Answer

The primary reason working with data in the data cache is faster than working with data in the data files is that the DBMS doesn't have to wait for the hard disk to retrieve the data. Data retrieval from hard disks is significantly slower than from memory (cache), where access times are much shorter.

Working with Data in the Data Cache Is Many Times