P2090-018 IBM Information Management DB2 10 Technical Mastery Test v3 Questions and Answers

Table partitioning allows you to make smaller tables automatically from large tables, thereby increasing the performance of your DB2 database.

Table partitioning allows you to create very large tables that are divided across multiple storage objects so that you can quickly attach and detach large quantities of data from the tables.

Table partitioning allows you to create result set tables from a join query, which automatically splits the data into smaller chunks, thereby increasing the performance of your DB2 database.

Table partitioning allows you to partition the table data based on the hash values of the primary key.

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

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

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

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