IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 - C2090-311 FREE EXAM DUMPS QUESTIONS & ANSWERS]

IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 - C2090-311 FREE EXAM DUMPS QUESTIONS & ANSWERS

Question 1

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

A. Index compression B. Temporary table compression C. Backup compression D. Row compression

Discussion 0

Correct Answer: C Vote an answer

Question 2

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.

Discussion 0

Correct Answer: A Vote an answer

Question 3

If the DB2_WORKLOAD registry variable is set to ANALYTICS, what value will be assigned to the DFT_DEGREE database configuration parameter, by default?

A. ANY B. ON C. -1 D. 1

Discussion 0

Correct Answer: C Vote an answer