GK Question

technology hard mcq

Which database design pattern stores historical changes to data by adding new rows instead of updating existing ones?

  1. Soft Delete
  2. Temporal Tables
  3. Event Sourcing
  4. Both B and C

Answer: Both B and C

Temporal Tables (SQL:2011 standard) automatically track row history with system-versioned tables. Event Sourcing stores state changes as immutable events, enabling reconstruction of any historical state. Both support audit trails, time-travel queries, and compliance. Trade-offs: increased storage and query complexity for historical analysis.

Topic Database & Programming
Exam Relevance Banking, SSC JE, UPSC