IBM IBM Certified System Administrator C2090-919 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.

  Correct Answer: ADE

• 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

  Correct Answer: CE

• 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.

  Correct Answer: D

• 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.

  Correct Answer: AE

• 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

  Correct Answer: A

• Question 6:

  Given the following customer table:

  

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: B

• 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.

  Correct Answer: D

• Question 8:

  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.

  Correct Answer: D

• Question 9:

  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.

  Correct Answer: D

• Question 10:

  Which of the following is NOT a step in setting up HDR for the first time?

  A. Take a level 0 backup of the primary.

  B. Useoninit -v to bring up the secondary.

  C. Execute a physical restore on the secondary.

  D. Useonmode -d to specify the secondary instance name.

  Correct Answer: B