IBM C2090-919 Online Practice Questions and Exam Preparation

IBM C2090-919 Online Questions & Answers

• Question 1:

  Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)

  A. The rootdbspace.
  B. The users' home directory.
  C. The $INFORMIXDIR/tmp directory.
  D. Thedbspace in which the active database was created.
  E. The /tmp directory or PSORT_DBTEMP.
  A. The rootdbspace.
  D. Thedbspace in which the active database was created.
  E. The /tmp directory or PSORT_DBTEMP.

• Question 2:

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

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

  Which two actions will occur when the following command is executed? (Choose two.) UPDATE STATISTICS HIGH AUTO

  A. Stored Procedures will be recompiled.
  B. Update statistics will run high on the table named AUTO.
  C. Update statistics will run high only on the first column of an index.
  D. Update statistics will run high only after the optimizer decides the statistics are too old.
  E. Update statistics will run high only on columns which meet the STATSCHANGE threshold.
  A. Stored Procedures will be recompiled.
  E. Update statistics will run high only on columns which meet the STATSCHANGE threshold.

• Question 5:

  Most, but not all Virtual Processors, can be modified via the onmode -p command. Which CANNOT be modified?

  A. ADM
  B. BTS
  C. CPU
  D. CSM
  A. ADM

• Question 6:

  Given the following customer table:

  

  A. 1
  B. 2
  C. 3
  D. 4
  B. 2

• Question 7:

  Which would provide the greatest performance benefit in a warehousing environment?

  A. Indexes on searched data.
  B. Short checkpoint durations.
  C. Large number ofbufferpool buffers.
  D. Optimize decision support memory.
  D. Optimize decision support memory.

• Question 8:

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

  Which of the following gives a good initial estimate for the physical log size?

  A. 110% ofrootdbs.
  B. 110% the default buffer pool.
  C. 110% of the logical log space.
  D. 110% of combined buffer pool.
  D. 110% of combined buffer pool.

• Question 10:

  Which statement is true when creating a table through a Grid operation with the replication option enabled?

  A. A separate replicate set is created for each table.
  B. ERKEY shadow columns are automatically added to the table.
  C. The replication for the table is defined with the always apply conflict resolution rule.
  D. All servers in the Enterprise Replication domain are included as participants in the replicate created.
  B. ERKEY shadow columns are automatically added to the table.