IBM IBM Certifications C2090-619 Questions & Answers

• Question 61:

  Assuming network connectivity between two Informix instances, which file may need additional configuration to allow distributed queries?

  A. sqlhosts

  B. /etc/services

  C. $ONCONFIG

  D. /etc/hosts.equiv

  Correct Answer: D

• Question 62:

  Which OpenAdmin Tool feature is used to analyze the state of the Informix database server and can alert the DBA through email?

  A. SQL Toolbox

  B. Health Advisor

  C. Server Administration

  D. Performance Analysis

  Correct Answer: B

• Question 63:

  What does the following SQL administration command do? EXECUTE FUNCTION task("onmode", "wi", "/tmp/cfg_20130601");

  A. Apply the new values for all configuration parameters in memory.

  B. Reset the values for dynamically updatable configuration parameters to the default values and save them in onconfig.

  C. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" in memory.

  D. Apply the new values for all dynamically updatable configuration parameters from the file "/tmp/cfg_20130601" and save them in onconfig.

  Correct Answer: C

• Question 64:

  Which object can be compressed?

  A. dictionary table

  B. temporary table

  C. attached b-tree index

  D. detached b-tree index

  Correct Answer: D

• Question 65:

  The DBA updated the uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands:The DBA updated the ?uto_crsd?Scheduler task in the SYSADMIN database with the following SQL commands: UPDATE ph_task SET tk_enable = ?WHERE tk_name = uto_crsd?UPDATE ph_task SET tk_enable = ??WHERE tk_name = ?uto_crsd? UPDATE ph_threshold SET value = ?WHERE name = UTODEFRAG_ENABLED?UPDATE ph_threshold SET value = ??WHERE name = ?UTODEFRAG_ENABLED? UPDATE ph_threshold SET value = ?000?WHERE name = UTOCOMPRESS_ROWS?UPDATE ph_threshold SET value = ?000?WHERE name = ?UTOCOMPRESS_ROWS? What will be the effect of auto_crsd database scheduler task on the tables?

  A. Compress all tables with less than 5000 rows.

  B. Compress and defragment tables with more than 5000 uncompressed rows.

  C. Compress, repack and shrink tables with more than 5000 uncompressed rows.

  D. Do not compress, repack, shrink and defragment any table with more than 5000 rows.

  Correct Answer: C

• Question 66:

  Which statement is FALSE regarding SBSPACES?

  A. They are recoverable.

  B. They do not obey transaction isolation modes.

  C. They have read, write, and seek properties similar to a standard UNIX file.

  D. Smart large objects within table rows are not required to be retrieved in one statement.

  Correct Answer: B

• Question 67:

  Which statement is NOT true about a Storage Pool?

  A. You can create multiple storage pools per database server.

  B. You can add, modify, delete, and purge storage pool entries.

  C. Priorities can be used to determine space allocation order.

  D. It consists of any combination of a raw device, a cooked file, or a directory.

  Correct Answer: A

• Question 68:

  Which is NOT a valid index fragmentation strategy?

  A. Fragment by Range

  B. Partition by Expression

  C. Fragment by Expression

  D. Fragment by Round Robin

  Correct Answer: D

• Question 69:

  Which statement is FALSE?

  A. A new index can be created compressed.

  B. Attached indexes cannot be compressed.

  C. A compressed index can be uncompressed.

  D. A compressed index cannot be uncompressed.

  Correct Answer: C

• Question 70:

  Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?

  A. SP_WAITTIME

  B. SP_THRESHOLD

  C. SP_AUTOEXPAND

  D. SP_CHUNKEXTEND

  Correct Answer: C