IBM C2090-311 Online Practice Questions and Exam Preparation

IBM C2090-311 Online Questions & Answers

• Question 1:

  What type of table can be converted into a column-organized table with the db2convert command?

  A. A range partitioned table
  B. A materialized query table
  C. A row-organized user table
  D. A declared global temporary table
  A. A range partitioned table

• Question 2:

  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.
  A. Whenever an individual row is deleted.

• Question 3:

  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
  A. POOL_COL_READS/ POOL COL READ REQS

• Question 4:

  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
  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

• Question 5:

  Which monitoring function can be used to determine how many times an SQL statement has referenced a particular column-organized table within a specific period of time?

  A. MON_GET_TABLE()
  B. MON_GET_TABLESPACE()
  C. MON_GET_UNIT_OF_WORK()
  D. MON_GET_TABLE_USAGE_LIST()
  A. MON_GET_TABLE()

• Question 6:

  Which statement about expression-based indexes is true?

  A. The RUNSTATS command cannot be used to collect statistics for expression-based indexes.
  B. Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys.
  C. Expression-based index keys consist of a concatenation of one or more specified table columns.
  D. The index key values of expression-based indexes are not the same as the values in the corresponding table columns.
  D. The index key values of expression-based indexes are not the same as the values in the corresponding table columns.

• Question 7:

  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.
  C. Setting the AUTO_RUNSTATS database configuration parameter to ON.

• Question 8:

  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
  A. INTRA_PARALLEL

• Question 9:

  If Self Tuning Memory Manager (STMM) is enabled for a DB2 10.5, FixPack 1 pureScale database, which two capabilities are available?

  A. Multi-tenancy
  B. Workload consolidation
  C. Independent tuning member
  D. Broadcasting STMM tuning decisions to all members
  E. Single INSTANCE_MEMORY instance configuration memory setting
  D. Broadcasting STMM tuning decisions to all members
  E. Single INSTANCE_MEMORY instance configuration memory setting

• Question 10:

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

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