IBM
C2090-312 · Question #187
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
The correct answer is B. A period-specification placed in the WHERE clause of a subselect E. A SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to. See the full explanation below for the reasoning.
Question
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
Options
- AA period-specification placed in the FROM clause of a subselect.
- BA period-specification placed in the WHERE clause of a subselect
- CA SELECT statement predicate against the transaction start ID of the base table.
- DA predicate against the start and end columns of the base table placed in the WHERE clause of a
- EA SET of the CURRENT TEMPORAL SYSTEM_TIME special register to a non-null value prior to
How the community answered
(41 responses)- A2% (1)
- B80% (33)
- C7% (3)
- D10% (4)
Community Discussion
No community discussion yet for this question.