Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
Which two options can be specified in order to access a system-period temporal table for a specific point in time guaranteeing accurate results?
A . A period-specification placed in the FROM clause of a subselect.
B . A period-specification placed in the WHERE clause of a subselect
C . A SELECT statement predicate against the transaction start ID of the base table.
D . A predicate against the start and end columns of the base table 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 a SELECT against the temporal table.
Answer: C,E
Subscribe
Login
0 Comments
Inline Feedbacks
View all comments