A. DB2 10 pureScale introduced support for split mirror technology as a backup method.

B. DB2 10 pureScale introduced support for range-partitioned tables. Attach/detach operations are limited to the first and last partitions only.

C. DB2 10 pureScale introduced support for partitioned indexes and partition reorgs.

D. DB2 10 pureScale is able to leverage DB2's Workload Manager.

A. Multi-Temperature Data Management

B. INGEST utility

C. Temporal Tables

D. Table Partitioning

A. db2instance -list -cfs -details

B. db2instance -display -cluster -modifications

C. db2instance -all -cfs

D. db2instance -list

A. Application-period temporal tables combine the historical tracking of a system-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.

B. System-period temporal tables combine the historical tracking of an Application-period temporal table with the time-specific data storage capabilities of a bitemporal table. They are used to keep user-based period information as well as system-based historical information.

C. Application-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.

D. System-period temporal tables are used to keep historical versions of records in a table. They use a history table to transparently store updated and deleted data rows.

A. The DB2 Audit facility allows you to export audit data into a table format for easy reporting.

B. The DB2 Audit facility helps monitor data access to protect against unknown or unwanted behavior.

C. The DB2 Audit facility logs configuration changes made by STMM.

D. The DB2 Audit facility helps you comply with business regulation or legal rules requiring companies to keep historical records of database activities.

A. In order to take advantage of this feature, applications must be changed to work with the RCAC feature.

B. Users with DATAACCESS authority are exempt from the Row and Column Access Control rules.

C. Table data is protected against direct access to the table. Access using views is unrestricted.

D. Row and column level access control allows the creation of column masks that can control what column values a user is permitted to see.

A. Temporal tables are complex to maintain and require major application changes.

B. Temporal tables require constant changes to the operating system timestamp in order to navigate through time in the database.

C. Temporal tables are used to model data in the past, present, and future.

D. Temporal tables are used to model data in the past and present. They cannot be used to model data in the future.