IBM IBM Certified System Administrator C2090-919 Questions & Answers

• Question 91:

  What statement about users accessing a Flexible Grid is true?

  A. Every user can execute commands on the Flexible Grid.

  B. Only userinformix can execute commands on a Flexible Grid.

  C. Users have to be authorized to execute Flexible Grid commands.

  D. Commands can only be executed from the node on which the Flexible Grid was created.

  Correct Answer: C

• Question 92:

  To maximize the performance of your OnBar backup and recovery operations, what should you do?

  A. Use a commercial storage manager.

  B. Use the bundled Informix Storage Manager (ISM).

  C. Use a combination of disk-based and tape-based backup devices.

  D. Use separate storage devices for instance spaces and logical logs.

  Correct Answer: D

• Question 93:

  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

  Correct Answer: CE

• Question 94:

  What is used during Fast Recovery to return pages to the original state?

  A. Logical Log

  B. Physical Log

  C. External Tables

  D. TemporaryDBSpaces

  Correct Answer: B

• Question 95:

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

  Which two onconfig parameters can be set to backup/restore to/from a cloud storage location? (Choose two.)

  A. TAPEDEV

  B. TAPEBLK

  C. LTAPEBLK

  D. LTAPEDEV

  E. BAR_BSALIB_PATH

  Correct Answer: AD

• Question 97:

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

  What ONCONFIG parameter can be tuned to increase memory for hash joins?

  A. RESIDENT

  B. EXTSHMADD

  C. VP_MEMORY_CACHE_KB

  D. DS_NONPDQ_QUERY_MEM

  Correct Answer: D

• Question 99:

  Which two options can be used to monitor PDQ resources? (Choose two.)

  A. onstat -l.

  B. onstat -p.

  C. onstat -D.

  D. onstat -g ath.

  E. SET EXPLAIN output.

  Correct Answer: DE

• Question 100:

  Which statement about updating statistics is NOT true?

  A. UPDATE STATISTICS HIGH scans the entire table.

  B. Data distributions are updated every time UPDATE STATISTICS LOW is executed.

  C. UPDATE STATISTICS operations will benefit by tuning the DBUPSPACE environment variable.

  D. An UPDATE STATISTICS LOW command will ignore tables and indexes with modifications less than STATCHANGE.

  Correct Answer: B