IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 (C2090-311) Free Practice Test

Question 1

Which statement about column-organized tables is true?

A. Databases with column-organized tables can be federated.

B. Queries that use the Currently Committed semantics can be used with column-organized tables.

C. Sort memory can be automatically tuned in environments containing column-organized tables.

D. Schemas that include column-organized tables can be transported.

Correct Answer: A

Question 2

Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?

A. Backup compression

B. Row compression

C. Temporary table compression

D. Index compression

Correct Answer: A

Question 3

By default, the Optim Workload Table Organization Advisor will recommend converting row-organized tables to column-organized tables if it determines that the change will improve query performance, as a whole, by how much?

A. 25 percent

B. 30 percent

C. 20 percent

D. 15 percent

Correct Answer: C

Welcome to TestSimulate

IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 (C2090-311) Free Practice Test