volume_mute
Speeding up storage search
publish date: 2025/09/08 20:34:41.037626 UTC
To speed up disk searches, the DBMS uses auxiliary files called (1), which are often based on tree or (2) data structures. The (3) module is responsible for maintaining parts of the database in main memory buffers.
Please drag and drop the selected option in the right place or type it instead
buffering or caching
indexes
hash
Correct Answer
(1) indexes
(2) hash
(3) buffering or caching
Explanation
A DBMS uses indexes as the auxiliary files, names "tree" and "hash" as the underlying structures, and describes the "buffering or caching module" for main memory management.
Reference
Fundamentals of database systems (7th edition)