The data cache or _____ is a shared, reserved memory area that stores the most recently accessed data blocks in RAM.
A) buffer cache
B) procedure cache
C) SQL cache
D) permanent storage

Question

Quizplus · Accepted Answer

The description of the shared, reserved memory area that stores the most recently accessed data blocks in RAM points to the buffer cache as the correct option. The SQL cache stores query execution plans, while the procedure cache stores stored procedures and execution plans. Permanent storage refers to non-volatile storage devices like the hard disk or solid-state drives.

The Data Cache or _____ Is a Shared, Reserved Memory