IBM IBM Certified Database Administrator C2090-311 Questions & Answers

• Question 21:

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

  A. BLU compression

  B. Value compression

  C. Actionable compression

  D. Adaptive row compression

  Correct Answer: A

• Question 22:

  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.

  Correct Answer: A

• Question 23:

  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

  Correct Answer: CD

• Question 24:

  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

  Correct Answer: A

• Question 25:

  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. 15 percent

  B. 20 percent

  C. 25 percent

  D. 30 percent

  Correct Answer: B

• Question 26:

  What formula can be used to determine the average number of column-organized pages found in each read request?

  A. POOL_COL_READS/ POOL COL READ REQS

  B. POOL_COL_P_READS/ POOL COL P READ REQS

  C. POOL_ASYNC_COL_READS/ POOL ASYNC COL READ REQS

  D. POOL ASYNC COL P READS/POOL ASYNC COL P READ REQS

  Correct Answer: A

• Question 27:

  Which command, when executed, will enable workload management for column-organized 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

  Correct Answer: C

• Question 28:

  If the DB2_WORKLOAD registry variable has not been set which database manager configuration parameter must be modified, before a query that accesses a column-organized table can be executed?

  A. INTRA_PARALLEL

  B. QUERY_HEAP_SZ

  C. MAXIMUM DEGREE

  D. SHEAPTHRES SHR

  Correct Answer: A

• Question 29:

  If the following commands are executed successfully:

  

  Which SQL statement will fail?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: C

• Question 30:

  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.

  Correct Answer: A