A. DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full
qualified name.

B. DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.

C. DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by
comparing the security labels between database objects and users.

D. DB2 LBAC monitors table data access and tables modifications made by database users.

A. 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.

B. 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.}

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

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

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 is a permission granted to a database table that allows the table the accessesrights to
load a backup database.

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

D. LOAD authority does not exist in DB2.

A. Multi-temperature data management reduces the total cost of ownership by allowing efficient
deployment of storage hardware with minimal administrative overhead.

B. Multi-temperature data management integrates with DB2's Workload Manager feature to let you
prioritize your workloads based on the data being accessed.

C. Multi-temperature data management best practices recommend that cold data should be stored in
faster devices in order to maximize overall system performance.

D. You can use storage groups to implement multi-temperature data management in DB2.

A. DB2 does not have wizard functionality.

B. DB2 wizards are DBAs that are considered the top of their field in DB2.

C. DB2 wizards are programs that assist you in completing a single task by stepping you through the task.

D. DB2 wizards programs are automated in DB2. They run as background processes of the database and
they automatically configure database parameters.

A. A table space is a logical storage grouping that can be composed of one or more containers.

B. A table space is a space reserved for catalog tables and base table data.

C. A table space is a DB2 component that manages access to databases.

D. A table space is an area of main memory that has been allocated by the database manager for the
purpose of caching table and index data as it is read from the physical media.

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

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

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

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

A. It is marked as deleted in the delete byte in the segment prefix.

B. It is physically deleted from the CI by zeroing the segment.

C. It is physically deleted from the CI, with the remaining segments moved towards the beginningof the CI.

D. A status code is returned to your program indicating segments cannot be deleted from aHISAM
database.

A. HADR with multiple standbys supports reads on all standby databases.

B. Implementation of a row and column access control policy is transparent to applications accessing the
database.

C. WLM is not supported in DB2 pureScale environments.

D. The INGEST utility is capable of transforming and loading data from files and pipes at high speeds into
DB2 tables.