Exam4Training

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

Exit mobile version