Advanced
Database Management Systems
Q93 / 100
What is temporal data management in databases?
Correct! Well done.
Incorrect.
The correct answer is B) Storing and querying data with time dimensions: transaction time (when stored) and valid time (real-world validity), enabled by SQL:2011 temporal tables
B
Correct Answer
Storing and querying data with time dimensions: transaction time (when stored) and valid time (real-world validity), enabled by SQL:2011 temporal tables
Explanation
Temporal databases track "valid time" (when a fact is true in the real world) and "transaction time" (when data was stored). SQL:2011 adds PERIOD, VERSIONING, and temporal JOINs for bitemporal queries.
Progress
93/100