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

PDF question preview Back to product

Reading controls

Reader tools

Free demo

5 of 30 questions

Purchase the full version to unlock every question and answer.

View the full question set

Preview tools

Try Web TestEngine

Question formats

Single choice4

Multiple choice1

IBM · C2090-311

Free C2090-311 Exam Dumps Preview

Preview real exam questions, verified answers and available explanations before choosing a study plan.

Question 1

Single choice

What are the correct steps to capture EXPLAIN information for column-organized tables?

A
1. Issue the query against column-organized tables
2. Execute the db2exfmt command
B
1. Execute the command CURRENT EXPLAIN MODE YES
2. Issue the query against column-organized tables
3. Execute the db2exfmt command
C
1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2. Issue the query against column-organized tables
3. Execute the db2exfmt command
D
1. Set the ENABLE_COLUMN_TABLES registry variable to YES
2. Execute the command CURRENT EXPLAIN MODE YES
3. Issue the query against column-organized tables
4. Execute the db2exfmt command

Reveal answer details Close answer details

Correct answerD

Question 2

Single choice

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
-1
B
1
C
ON
D
ANY

Reveal answer details Close answer details

Correct answerA

Question 3

Single choice

Which type of compression is typically used with column-organized tables?

A
BLU compression
B
Value compression
C
Actionable compression
D
Adaptive row compression

Reveal answer details Close answer details

Correct answerA

Question 4

Multiple choice

Which two sources can be used to provide input to the InfoSphere Optim Query Workload Tuner that generate EXPLAIN information when creating the query workload?

A
db2pd
B
Routines
C
EXPLAIN tables
D
Snapshot monitor
E
ACTIVITIES event monitors

Reveal answer details Close answer details

Correct answersC, D

Question 5

Single choice

Which statement about column-organized tables is true?

A
Databases with column-organized tables can be federated.
B
Schemas that include column-organized tables can be transported.
C
Sort memory can be automatically tuned in environments containing column-organized tables.
D
Queries that use the Currently Committed semantics can be used with column-organized tables.

Reveal answer details Close answer details

Correct answerA