GK Question

technology medium mcq

Which database optimization technique stores frequently accessed data in faster memory?

  1. Indexing
  2. Caching
  3. Partitioning
  4. Replication

Answer: Caching

Caching (Redis, Memcached) stores hot data in RAM for sub-millisecond access, reducing database load. Critical for high-traffic applications. Trade-offs: cache invalidation, consistency.

Topic Database Technologies
Exam Relevance Banking, SSC JE, UPSC