IBM C2090-614 Online Practice Questions and Exam Preparation

IBM C2090-614 Online Questions & Answers

• Question 11:

  Which procedure is used to Explain an SQL statement using information obtained from the package cache or the package cache event monitor?

  A. EXPLAIN_FROM_DATA
  B. EXPLAIN_FROM_ACTIVITY
  C. EXPLAIN_FROM_SECTION
  D. EXPLAIN_FROM_CATALOG
  C. EXPLAIN_FROM_SECTION

• Question 12:

  What is the default user workload class that is created for each database table?

  A. DEFAULT_USER
  B. SYSUSERDEFAULTWLM
  C. SYSDEFAULTUSERWORKLOAD
  D. SYS_DEFAULT_USER_WORKLOAD
  C. SYSDEFAULTUSERWORKLOAD

• Question 13:

  Which diagnostic tool can be used to collect metrics on individual SQL statement executions?

  A. db2dart
  B. A snapshot monitor
  C. A statement event monitor
  D. The MON_GET_UNIT_OF_WORK_DETAILS table function
  C. A statement event monitor

• Question 14:

  Which operation can be performed by executing an ALTER STOGROUP statement?

  A. Change the name of an existing storage group.
  B. Make an existing storage group the default storage group.
  C. Reduce the current high water mark of all table spaces that have been assigned to a storage group.
  D. Specify the average time, in milliseconds, that it takes to read one page of data from the slowest storage path used by a storage group.
  B. Make an existing storage group the default storage group.

• Question 15:

  Which statement about block indexes is correct?

  A. Because of their large size, block indexes are extremely efficient.
  B. Block indexes improve performance when data is not clustered on sequential pages.
  C. Prefetching of data pages relies on sequential detection when block indexes are used.
  D. The records for each block are retrieved using a mini-relational scan of saved data pages.
  C. Prefetching of data pages relies on sequential detection when block indexes are used.

• Question 16:

  In what situation should you use a redirected restore operation?

  A. You want to drop a storage group during a restore process.
  B. You want to move data from one operating system to another.
  C. You want to restore you table spaces into new storage groups.
  D. You want to restore your table space containers into a different physical location.
  D. You want to restore your table space containers into a different physical location.

• Question 17:

  The following statement was used to create a table space named USER_TMP in a non-partitioned database:

  CREATE USER TEMPORARY TABLESPACE user_tmp MANAGED BY SYSTEM USING (mnt/fsystem4 mnt/fsystem5

  Which operation can be performed on the USER_TMP table space with an ALTER TABLESPACE statement?

  A. New storage containers can be added to it.
  B. A different buffer pool can be associated with it.
  C. A hard limit can be placed on the size to which its storage containers can grow.
  D. Its high water mark can be lowered and its size can be reduced to the high water mark.
  B. A different buffer pool can be associated with it.

• Question 18:

  In which situation would you NOT use a redirected restore?

  A. To redefine the paths of a defined storage group.
  B. To move table space containers onto different physical devices.
  C. To restore a backup image from one operating system to another.
  D. To restore a backup image to a target machine that is different from the source machine.
  C. To restore a backup image from one operating system to another.

• Question 19:

  You recently added more storage to a table space and a rebalance operation was started automatically. How can you pause the rebalance operation?

  A. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 0.
  B. Set the dynamic instance registry variable UTIL_IMPACT_LIM to 100.
  C. Issue a LIST UTILITIES statement with the 'SUSPEND ' option specified.
  D. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.
  D. Issue an ALTER TABLESPACE statement with the 'REBALANCE SUSPEND' option specified.

• Question 20:

  Which category must be enabled before db2audit will record the creation of new buffer pools?

  A. OBJMAINT
  B. SECMAINT
  C. CHECKING
  D. OBJCREATE
  A. OBJMAINT