IBM C2090-611 Exam Questions & Answers

Which statement about adaptive compression is true?

A. When you enable adaptive compression for a table, you enable it for the entire table, even if the table contains more than one partition.

B. You can specify that tables be compressed by using either a table-level dictionary only, page-level dictionaries only, or both table-level andpage-level dictionaries.

C. Adaptive compression can only be used to compress base tables, partitioned tables, and temporary tables; MQTs, typed tables and stagingtables cannot be compressed.

D. Adaptive compression uses a page-level dictionary-based compression algorithm to compress data based on repeating patterns found within asampling of data from one extent.

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

Which statement regarding SECADM authority is true?

A. The instance owner has SECADM authority by default.

B. PUBLIC cannot receive SECADM authority, either directly or indirectly.

C. Only users with SECADM authority are allowed to grant the CONNECT database authority to others.

D. The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.