C2090-311 Exam - Free IBM Questions and Answers

Question #11 (Topic: )

When the DB2_COMPATIBILITY_VECTOR registry variable is set to ORA, what is the
maximum row width size for database tables?

A. 32 KB B. 64 KB C. 1MB D. 2 MB

Answer: B

Question #12 (Topic: )

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

Question #13 (Topic: )

Which statement about expression-based indexes is true?

A. The RUNSTATS command cannot be used to collect statistics for expression-based indexes. B. Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys. C. Expression-based index keys consist of a concatenation of one or more specified table columns. D. The index key values of expression-based indexes are not the same as the values in the corresponding table columns.

Answer: D

Question #14 (Topic: )

If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale
database, which two capabilities are available?

A. Multi-tenancy B. Workload consolidation C. Independent tuning member D. Broadcasting STMM tuning decisions to all members E. Single INSTANCE_MEMORY instance configuration memory setting

Answer: D,E

Question #15 (Topic: )

If the following commands are executed successfully:
[IBM-C2090-311-7.0/IBM-C2090-311-6_2.png]
Which SQL statement will fail?
[IBM-C2090-311-7.0/IBM-C2090-311-7_2.png]

A. Option A B. Option B C. Option C D. Option D

Answer: C

IBM C2090-311 - IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam