GK Question

technology medium mcq

Which database optimization technique reorganizes data storage to improve query performance?

  1. Indexing
  2. Partitioning
  3. Clustering
  4. All of these

Answer: All of these

Indexing speeds lookups; partitioning splits large tables; clustering physically orders data by key. All improve query performance. Critical for database tuning questions.

Topic Database Technologies
Exam Relevance Banking, SSC JE, UPSC