PrepAway - Latest Free Exam Questions & Answers

What needs to be defined in order to track changes made to a system-period temporal table over time?

What needs to be defined in order to track changes made to a system-period temporal table over
time?

PrepAway - Latest Free Exam Questions & Answers

A.
Once the row-begin, row-end, and transaction-start-id columns are created, all changes are
tracked.

B.
A history table must be created with identical columns to the base table and a unique index
must be defined on the transaction-start-id column.

C.
A history table must be created as a clone table of the base table after the row-begin, row-end,
and transaction-start-id columns have beendefined.

D.
A history table must be created with identical columns to the base table and then the base table
altered with the ADD VERSIONING clause torelate it to the history table.

Explanation:


Leave a Reply