IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 91:

  Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

  A. To avoid LRU flushes.
  B. To ensure the buffer pool is always available.
  C. To ensure theonstat -g ckp report is accurate.
  D. To avoid transaction blocking during checkpoints.
  D. To avoid transaction blocking during checkpoints.

• Question 92:

  Given the two indexes defined on table tab1:

  

  Which optimization method may be used?

  A. STAR_JOIN
  B. MULTI_INDEX
  C. OUTER_INDEX
  D. INDEX_SELFJOIN
  B. MULTI_INDEX

• Question 93:

  Which command line utility displays real time statistics about the instance?

  A. dbinfo
  B. onstat
  C. dbschema
  D. onmachinfo
  B. onstat

• Question 94:

  What two parameters can affect how often checkpoints occur? (Choose two.)

  A. LOGSIZE
  B. PHYSFILE
  C. LTAPEDEV
  D. BUFFERPOOL
  E. BAR_PROGRESS_FREQ
  A. LOGSIZE
  B. PHYSFILE

• Question 95:

  Fragment level statistics are NOT supported with which fragmentation strategy?

  A. List fragmentation.
  B. Interval fragmentation.
  C. Expression fragmentation.
  D. Round-robin fragmentation.
  D. Round-robin fragmentation.

• Question 96:

  Which statement about auditing is NOT true?

  A. You can enable auditing row updates for all rows in the table.
  B. You can enable auditing row updates just for a subset of rows in the table.
  C. You can enable auditing row updates for all rows from all tables in the database except for system catalog tables.
  D. You can enable auditing row updates for all rows from all tables in the database and for the system catalog tables.
  B. You can enable auditing row updates just for a subset of rows in the table.

• Question 97:

  Which sbspaces statement is FALSE?

  A. Sbspaces may be recoverable.
  B. Sbspaces can be of varying page size.
  C. Sbspaces may be part of round robin fragmentation.
  D. Sbspaces have read, write and seek properties similar to UNIX functions.
  B. Sbspaces can be of varying page size.

• Question 98:

  Which $ONCONFIG parameter must be set enable parallel OnBar backup operations?

  A. BAR_MAX_BACKUP
  B. BAR_SIZE_FACTOR
  C. BAR_PERFORMANCE
  D. BAR_NB_XPORT_COUNT
  A. BAR_MAX_BACKUP

• Question 99:

  What two onconfig parameters will help improve performance of new network connections? (Choose two.)

  A. NETTYPE
  B. VPCLASS
  C. NS_CACHE
  D. FET_BUF_SIZE
  E. NUMFDSERVERS
  C. NS_CACHE
  E. NUMFDSERVERS

• Question 100:

  What does the ovbuff field of an onstat -p output show?

  A. The number of times that a buffer was read.
  B. The number of times a buffer was extended.
  C. The number of times that any buffer was overwritten.
  D. The number of times the instance ran out offree buffers.
  D. The number of times the instance ran out offree buffers.