IBM C2090-614 - DB2 10.1 Advanced DBA for Linux UNIX and Windows Exam

Page:    1 / 22   
Total 108 questions

Which table configuration CANNOT utilize multi-temperature storage?

  • A. A range-partitioned table utilizing multiple table spaces that map to DMS containers.
  • B. Multiple tables containing the same data at different ages placed into the same table space.
  • C. Multiple tables containing the same data at different ages placed into separate table spaces.
  • D. A range-partitioned table utilizing multiple table spaces that map to individual storage groups.


Answer : B

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

  • A. New table spaces will start consuming storage on the new path.
  • B. Existing table spaces will not consume storage on the new path.
  • C. The storage group will be placed in "Rebalance Pending" mode.
  • D. DB2 will verify that space is available on the storage path specified.


Answer : B

Which Workload Manager (WLM) objects can the COLLECT ACTIVITY DATA clause be used with?

  • A. Data class, work class, and a limit
  • B. Data class, action class, and a threshold
  • C. Service subclass, action class, and a limit
  • D. Service subclass, work class, and a threshold


Answer : D

The following query is executed frequently against the SALES table: SELECT sales_person, region FROM sales WHERE region = 'Quebec' Which statement will create an index for optimal query performance?

  • A. CREATE INDEX sales_idx ON sales (region)
  • B. CREATE INDEX sales_idx ON sales (sales_person)
  • C. CREATE INDEX sales_idx ON sales (region, sales_person)
  • D. CREATE INDEX sales_idx ON sales (region) INCLUDE (sales_person)


Answer : C

To configure instance-level auditing with db2audit, which authority is required?

  • A. SYSADM
  • B. SYSCTRL
  • C. SECADM
  • D. SYSMAINT


Answer : A

Page:    1 / 22   
Total 108 questions