Which of the following statements about a system-period temporal table is TRUE?

Which of the following statements about a system-period temporal table is TRUE?
A . Rows can be archived into a history table which is always read only
B . Every row has a pair of timestamps which is set and managed by the application
C . AN SQL query for auditing can be run against current data or history data, but not both
D . The table contains only the current active rows

Answer: B

Explanation:

Explanation In a system-period temporal table, every row has a pair of timestamps, which are set by the DB2 system and recorded in the begin_column and end_column columns. DB2 uses the SYSTEM_TIME period to audit the data changes. It provides the application with the database managed row begin and row end timestamp maintenance, providing non-overlapping time periods with no gaps in time.

Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-1410temporal-tables-db2zos/ index.html

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments