C2090-611 Online Practice Questions and Answers

What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

A. Set

B. Tree

C. Group

D. Range

E. Hierarchy

Which authority is required to revoke SECADM authority?

A. DBADM

B. SECADM

C. SYSADM

D. SQLADM

Which tool can be used to mimic statistics for tables by gathering statistics from a production database and placing them into a test database?

A. db2pd

B. db2dart

C. db2look

D. db2mimic

Which two conditions must be met before Automatic Dictionary Creation (ADC) can be used to generate a compression dictionary for a table? (Choose two.)

A. The table is not a system temporary table.

B. The table contains a sufficient amount of data.

C. A table-level compression dictionary does not already exist for the table.

D. A page-level compression dictionary does not already exist for the table.

E. The table does not have any indexes defined on it that have not been enabled for compression.

By analyzing EXPLAIN data, you notice that a table scan is being performed instead of an index scan even though an index exists. In order to utilize the existing index, what should be done before issuing the RUNSTATS command to collect statistics for both the index and table?

A. Drop and reload the table.

B. Drop and recreate the index.

C. Reorganize the table to cluster its data according to that index.

D. Reorganize the table to cluster its index according to that query plan.

Which user-managed file system is required for DB2 pureScale deployments?

A. JFS2

B. NTFS

C. HPFS

D. GPFS

Which registry variable is used to enable transparent Lightweight Directory Access Protocol (LDAP)?

A. DB2LDAP

B. DB2AUTH

C. CLNT_PW_PLUGIN

D. SRVCON_PW_PLUGIN

What is the purpose of the Design Advisor?

A. To recommend physical changes to objects in a database.

B. To recommend database configuration parameter changes.

C. To generate profiles for autonomic activity within the database.

D. To generate query definitions required to create usage reports.

What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

A. To terminate a failed INGEST command.

B. To restart a failed INGEST command from the beginning.

C. To clean up the log records of a failed INGEST command.

D. To restart a failed INGEST command from the last commit point.

Which statement about DB2 aggregate registry variables is true?

A. An aggregate registry variable that is explicitly set by an application cannot be overwritten.

B. An aggregate registry variable overrides any corresponding explicitly set registry variable.

C. A registry variable that is explicitly set by an application can only be overwritten by aggregate registry variable.

D. A registry variable that is implicitly configured through an aggregate registry variable may also be explicitly defined.