Which statement about bitemporal tables is valid?
A.
Bitemporal tables are system tables and can only be queried by the schema owner.
B.
Querying a bitemporal table will produce results for a complete timeline; a view must be
created to obtain results for a specific time period.
C.
Creating a bitemporal table is similar to creating a regular table except users must
specify a system time period column.
D.
When data in a bitemporal table is updated, a row is added to it’s associated history
table.
D)
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0058481.html
Updating data in a bitemporal table results in rows that are added to its associated history table and can potentially result in rows that are added to the bitemporal table itself.
0
0