IBM C2090-311 - IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 Exam
Page: 2 / 6
Total 30 questions
Question #6 (Topic: )
When does space reclamation for a column-organized table normally occur?
A. Whenever an individual row is deleted.
B. Whenever an individual row is updated.
C. After all rows in an extent have been updated.
D. After all rows in an extent where updates took place have been deleted.
Answer: A
Question #7 (Topic: )
Which command, when executed, will enable workload management for column-organized
table workloads?
table workloads?
A. db2setDB2_WORKLOAD=ANALYTICS
B. db2set DB2_WLM_DISP_CONCUR=START
C. UPDATE DBM CFG USING WLM_DISPATCHER YES
D. UPDATE DBM CFG USING WORKLOAD TYPE ANALYTICAL
Answer: C
Question #8 (Topic: )
Which type of compression is typically used with column-organized tables?
A. BLU compression
B. Value compression
C. Actionable compression
D. Adaptive row compression
Answer: A
Question #9 (Topic: )
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?
row-organized tables to column-organized tables if it determines that the change will
improve query performance, as a whole, by how much?
A. 15 percent
B. 20 percent
C. 25 percent
D. 30 percent
Answer: B
Question #10 (Topic: )
What will cause the creation of a column-organized table to fail?
A. Setting the database code set to UNICODE.
B. Setting the DFT_DEGREE database configuration parameter to ANY.
C. Setting the AUTO_RUNSTATS database configuration parameter to ON.
D. Setting the UTILJHEAP_SZ database configuration parameter to at least 1.000,000 pages.
Answer: C
