IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 111:

  Which two objects are NOT included in a backup? (Choose two.)

  A. Tables
  B. Indexes
  C. External tables
  D. Simple blob data stored in simpleblobspaces
  E. Basic text search indexes stored in externaldbspaces
  C. External tables
  E. Basic text search indexes stored in externaldbspaces

• Question 112:

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

  Which option would be used with "cdr define replicate" to create a shadow replicate?

  A. --backup
  B. --mirrors
  C. --shadow
  D. --synchronize
  B. --mirrors

• Question 114:

  Which of the following is NOT in the machine notes?

  A. Operating system requirements.
  B. Critical kernel tuning parameters.
  C. A descriptive list of the new features in the port.
  D. Featuresthat are not available for the version and O/S.
  C. A descriptive list of the new features in the port.

• Question 115:

  Which action will NOT occur when the following command is executed? UPDATE STATISTICS HIGH

  A. Recompile all stored procedures.
  B. Update statistics low on all tables.
  C. Update statistics high on all tables.
  D. Update statistics medium on all tables.
  D. Update statistics medium on all tables.

• Question 116:

  What output is NOT reported by the dbschema utility?

  A. The database logging mode.
  B. The schemas of remote databases.
  C. The table definitions without owner names.
  D. Theonspaces commands to re-create your systems' dbspaces.
  A. The database logging mode.

• Question 117:

  How can ER onconfig parameters be modified dynamically?

  A. cdr set onconfig
  B. cdr tune onconfig
  C. cdr define onconfig
  D. cdr change onconfig
  D. cdr change onconfig

• Question 118:

  Identify a scenario when you CANNOT use in-place migration?

  A. When you want to change database locale.
  B. When you want to migrate from a 32-bit to a 64-bit port of Informix.
  C. When you want to defragment some of the heavily fragmented tables.
  D. When you want to use new configuration features in the new Informix version.
  A. When you want to change database locale.

• Question 119:

  Which statement about automatic space management is true?

  A. Spaces cannot be extended manually.
  B. Onlyunmirrored spaces can be extended.
  C. Mirrored andunmirrored spaces can be extended.
  D. The time interval for low storage space checks is not user configurable.
  B. Onlyunmirrored spaces can be extended.

• Question 120:

  A storage pool entry can be used to do what?

  A. Increase the size of a chunk.
  B. Increase the size of the logical logs.
  C. Increase the size of the physical log.
  D. Increase the size of a storage space.
  D. Increase the size of a storage space.