C2090-614

C2090-614 practice questions, page 2 of 5, with answer review and explanations.

Question 6

Consider the following statement: Which indexes should be created for optimal query performance?

  1. CREATE INDEX emp_idx ON employee (workdept); CREATE INDEX dept_idx ON department (deptno);
  2. CREATE INDEX emp_idx ON employee (workdept) CLUSTER; CREATE INDEX dept_idx ON department (deptname, deptno);
  3. CREATE INDEX emp_idx ON employee (workdept, lastname, job); CREATE INDEX dept_idx ON department (deptname, deptno);
  4. CREATE INDEX emp_idx ON employee (lastname, job, workdept) CLUSTER;

Question 7

What will occur when a database administrator adds a new automatic storage path to an existing storage group?

  1. New table spaces will start consuming storage on the new path.
  2. Existing table spaces will not consume storage on the new path.
  3. The storage group will be placed in "Rebalance Pending" mode.
  4. DB2 will verify that space is available on the storage path specified.

Question 8

Which monitoring tool can be used to obtain stripe set information for database managed storage table spaces?

  1. The MON_GET_CONTAINER table function.
  2. The SNAP_GET_TBSP_PART table function.
  3. The SNAPTBSP_RANGE administrative view.
  4. The TS_GET_CONTAINER administrative view.

Question 9

Which statement about value compression is correct?

  1. To use value compression, you must have a license for the DB2 Storage Optimization Feature.
  2. Value compression uses a page-level dictionary-based compression algorithm to compress data based on repetition of values found in a single column.
  3. Value compression involves removing duplicate entries for a value, only storing one copy, and keeping track of the location of any references to the stored copy.
  4. When value compression is used, the byte count of compressed NULLs, zeros, and blanks might be larger than that of the uncompressed version of the same

Question 10

Which statement about compression dictionaries is FALSE?

  1. Page-level dictionaries are stored in hidden rows within the table.
  2. Table-level dictionaries are stored in hidden rows within the table.
  3. Page-level dictionaries are automatically created or recreated by the database manager as pages are filled.
  4. Table-level dictionaries are automatically created or recreated as by the database manager as pages are filled.