题目内容

What needs to be defined in order to track changes made to a system-period temporal table overtime、

2024-07-09

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 beendefine

D.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 tabl

题目答案

查看最佳答案免验证查看最佳答案

试卷相关题目

1Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions、
A.View
B.Table
C.Sequence
D.Identity Column
开始考试点击查看答案
2Which object can a buffer pool be assigned to、
A.Schema
B.Table space
C.Storage group
D.Stored procedure
开始考试点击查看答案
3Which statement about bitemporal tables is valid、
A.Bitemporal tables are system tables and can only be queried by the schema owner.
B.Creating a bitemporal table is similar to creating a regular table except users must specify a system time period column.
C.When data in a bitemporal table is updated, a row is added to it's associated history table.
D.Querying a bitemporal table will produce results for a complete timeline; a view must be created to obtain results for a specific time period.
开始考试点击查看答案
4Which protocol provides applications the ability to connect to and update multiple DB2 databases within the same transaction、
A.Type-1 connect
B.Type-2 connect
C.Type-3 connect
D.Type-4 connect
开始考试点击查看答案
5Which two DB2 objects can a view be derived from、 (Choose two.)
A.View
B.Index
C.Table
D.Trigger
E.Procedure
开始考试点击查看答案
6Which object is used to cache table and index data as it is read from disk、
A.Database
B.Buffer pool
C.Table space
D.Package cache
开始考试点击查看答案
7Which statement about large object (LOB) locators is true、
A.A LOB locator is a data type that is used to store LOB data in binary files.
B.A LOB locator is a data type that is used to store LOB data in a database.
C.A LOB locator represents a value for a LOB resource that is stored in a database.
D.A LOB locator represents a value for a LOB resource that is stored in a binary fil
开始考试点击查看答案
8Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads、
A.DB2 Connect
B.DB2 pureScale
C.Workload Manager
D.High Availability Disaster Recovery
开始考试点击查看答案
9What type of large object (LOB) is used to store LOB data together with the formatted rows on data pages, instead of in a separate LOB storage object、
A.inline
B.binary
C.internal
D.partitioned
开始考试点击查看答案
10Which product replaced the Control Center used in versions prior to DB2 v10、
A.IBM Data Studio
B.IBM Administrator
C.IBM Data Manager
D.IBM Command Center
开始考试点击查看答案