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. LOAD authority is at the database level. When combined with the INSERT privilege on a table,it allows the user to load data into that table.

B. LOAD authority in DB2 is the main DBA in your organization that allows for a database to beloaded.

C. LOAD authority is a permission granted to a database table that allows the table the accessesrights to load a backup database.

D. LOAD authority does not exist in DB2.

A. Temporary Tables Compression

B. Classic Row Compression

C. Adaptive Compression

D. Declared Global Temporary Tables Compression

A. The DB2 export utility exports data from a table or view to a file.

B. The DB2 export utility is a command-line interface that allows you to export your entire DB2database into another vendor database format, which you specify as a command-line option.

C. The export utility does not exist in DB2.

D. The DB2 export utility allows you to import data that was exported from another DB2 databaseinto one of your specified tables.

A. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.}

B. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence).

C. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.

D. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence).

A. Authorization is a process that checks whether you have sufficient privileges to perform the desired database operation.

B. Authorization is the process where the DB2 database checks with Windows security to see if you have access to the DB2 database.

C. Authorization is the process where the DBA gathers information to see who will have access to the database.

D. Authorization is a process that validates that you are who you claim to be by verifying your user ID and password.

A. Tables are made up attributes called columns and rows.

B. Tables are comprised of main attributes called platform and legs.

C. Tables are comprised of 3 attributes in DB2. These are the top, the bottom, and the sides.

D. Tables exist outside of the DB2 database with a single attribute called the table diagonal.

A. PVU (Processor Value Unit) licensing

B. Authorized User (AU) licensing

C. Per Server licensing

D. Sub-capacity licensing

A. Authorization is the process where the DBA gathers information to see who will have access tothe database.

B. Authorization is a process that validates that you are who you claim to be by verifying youruser ID and password.

C. Authorization is a process that checks whether you have sufficient privileges to perform thedesired database operation.

D. Authorization is the process where the DB2 database checks with Windows security to see ifyou have access to the DB2 database.