IBM C2090-311 Certification Exam Material - Free Download and Guaranteed Pass

IBM C2090-311 Certification Exam Material - Free Download and Guaranteed Pass



 Exam code : C2090-311

Exam name : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1



How is the Query Workload Tuner license installed and enabled?

A. With Data Studio, using the license activation kit.

B. By executing the db2licm command after data server installation.

C. With the Optim Performance Manager Server, using the license activation kit.

D. By running the Query Workload Tuner license activation command on the appropriate

WebSphere server.

Answer: A

If the DB2_WORKLOAD registry variable has not been set which database manager

configuration parameter must be modified, before a query that accesses a columnorganized

table can be executed?

A. INTRA_PARALLEL

B. QUERY_HEAP_SZ

C. MAXIMUM DEGREE

D. SHEAPTHRES SHR

Answer: A

If the following commands are executed successfully:

Which SQL statement will fail?

A. Option A

B. Option B

C. Option C

D. Option D

Answer: C