GK Question

technology medium mcq

Which database feature automatically distributes data across multiple nodes for scalability?

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

Answer: Sharding

Sharding partitions data horizontally across nodes based on key ranges or hashes, enabling horizontal scaling. Critical for handling large datasets in distributed databases. Trade-offs: cross-shard queries complexity.

Topic Database Technologies
Exam Relevance Banking, SSC JE, UPSC