Multiple choice technology databases

What is the best table to be cached?

  1. Small table rarely retrieved with a full table scan

  2. Large table rarely retrieved with a full table scan

  3. Small table frequently retrieved with a full table scan

  4. Large table frequently retrieved with a full table scan
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Caching tables in database systems is most beneficial for small tables that are frequently retrieved with a full table scan. Keeping these small tables in cache memory avoids disk I/O costs. Large tables require too much cache space, and rarely retrieved tables do not yield enough performance improvement to justify cache space.

Keep practicing — related questions