C2090-320 · Question #113
Which of the following statements about a system-period temporal table is TRUE?
The correct answer is B. Every row has a pair of timestamps which is set and managed by the application. 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…
Question
Which of the following statements about a system-period temporal table is TRUE?
Options
- ARows can be archived into a history table which is always read only
- BEvery row has a pair of timestamps which is set and managed by the application
- CAN SQL query for auditing can be run against current data or history data, but not both
- DThe table contains only the current active rows
How the community answered
(16 responses)- A6% (1)
- B75% (12)
- C13% (2)
- D6% (1)
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. db2zos/index.html
Topics
Community Discussion
No community discussion yet for this question.