GK Question

technology medium mcq

Which database feature enables time-travel queries to access historical data states?

  1. Temporal Tables
  2. Point-in-Time Recovery
  3. Both A and B
  4. Neither

Answer: Both A and B

Temporal Tables (SQL:2011) automatically track row history; PITR restores database to specific timestamp. Critical for audit, compliance, and debugging.

Topic Database Technologies
Exam Relevance Banking, SSC JE, UPSC