IBM DB2 11.1 DBA for LUW - C2090-600 Exam Questions [2026]

QUESTION NO: 1
Which command will enable Explicit Hierarchical Locking (EHL) in a DB2 pureScale environment?

A. UPDATE DB CFG USING LOCKLIST AUTOMATIC MAXLOCKS AUTOMATIC B. UPDATE DB CFG USING CF LOCK_SZ AUTOMATIC C. UPDATE DB CFG USING OPT_DIRECT_WRKLD YES D. UPDATE DB CFG USING LOCKLIST 4096 MAXLOCKS 90

Correct Answer: D

QUESTION NO: 2
Which of the following are valid Explain operators? (Choose two.)

A. COLSCAN B. SELECT C. CTQ D. XSCAN E. IXSCAN

Correct Answer: D,E

QUESTION NO: 3
Which of the following statements is TRUE?

A. REORGCHK automatically run stables reorganization. B. REORGCHK can only be used for user tables, not for system tables. C. REORGCHK can be used to verify the level of data fragmentation and indicate whether reorganization might be required. D. REORGCHK uses only current table and index statistics.

Correct Answer: D

QUESTION NO: 4
Which operation can be performed with trusted context privileges that are acquired through a role?

A. Server maintenance operations B. DDL operations C. DML operations D. Security administration operations

Correct Answer: C

QUESTION NO: 5
You receive a large data file that contains large object data values that need to be copied into a table in the shortest amount of time possible. Which utility should be used?

A. TRANSPORT B. LOAD C. INGEST D. IMPORT

Correct Answer: D

QUESTION NO: 6
Which statement about NOT ENFORCED unique constraints is TRUE?

A. Storage requirements for a NOT ENFORCED unique constraint are no different than the storage requirements for a similar unique index B. NOT ENFORCED unique constraints can not be defined on primary key columns C. When attempting to insert data that does not conform to a NOT ENFORCED unique constraint, a warning will be returned D. The query optimizer will consider a NOT ENFORCED unique constraint when selecting an optimal data access plan

Correct Answer: B