IBM IBM Certifications C2090-619 Questions & Answers

• Question 11:

  Which feature can be enabled in Informix?

  A. Automatic addition of a CPU VP.

  B. Automatic addition of an ADM VP.

  C. Automatic extension of storage spaces.

  D. Automatic addition of message log files.

  Correct Answer: C

• Question 12:

  Which parameter can automatically adjust other configuration parameters that are not present in the configuration file?

  A. AUTO_PERF

  B. AUTO_TUNE

  C. AUTO_CONFIG

  D. AUTO_ENABLE

  Correct Answer: B

• Question 13:

  Which SQL statement is used to remove detailed statistical information from the sysdistrib catalog table?

  A. UPDATE STATISTICS DISTRIBUTIONS ONLY

  B. UPDATE STATISTICS LOW DROP DISTRIBUTIONS

  C. UPDATE STATISTICS LOW REMOVE DISTRIBUTIONS

  D. UPDATE STATISTICS MEDIUM REMOVE DISTRIBUTIONS

  Correct Answer: B

• Question 14:

  Which option provides the greatest performance benefit in an Informix warehouse environment?

  A. Setting lower value of PDQPRIORITY.

  B. Increasing the number of B-Tree cleaners.

  C. Setting higher value of DS_TOTAL_MEMORY.

  D. Setting value of OPT_GOAL configuration variable to 0.

  Correct Answer: C

• Question 15:

  Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

  A. CKPTINTVL

  B. RA_PAGES

  C. CLEANERS

  D. SHMVIRTSIZE

  Correct Answer: C

• Question 16:

  The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

  A. The user encounters a lock request error.

  B. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

  C. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

  D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

  Correct Answer: C

• Question 17:

  Which two statements are true?

  A. Temporary dbspaces can have different page sizes.

  B. Separate temporary dbspaces are required for each buffer pool.

  C. DBSPACETEMP dbspaces can be temporary or standard dbspaces.

  D. If rootdbs is mirrored then all the temporary spaces must be mirrored.

  E. If DBSPACETEMP is not configured then temporary space will never be used.

  Correct Answer: AC

• Question 18:

  Which is NOT a valid option to improve service for connection requests under TCP/IP protocol?

  A. Adding sm_listen threads.

  B. Adding listener threads for additional ports.

  C. Dynamically increase the number of listener threads using onmode -P commands.

  D. Adding an additional network-interface card to service Informix connection requests.

  Correct Answer: A

• Question 19:

  How do the MAX_PDQPRIORITY onconfig parameter and the PDQPRIORITY environment variable work together to constrain access to PDQ resources?

  A. PDQPRIORITY is the only constraint.

  B. MAX_PDQPRIORITY is the only constraint.

  C. The minimum of the two values is the actual constraint.

  D. The constraint is MAX_PDQPRIORITY / 100 * PDQPRIORITY / 100.

  Correct Answer: D

• Question 20:

  Which two statements are true about Enterprise Replication of TimeSeries data types? (Choose two.)

  A. ATS and RIS files must be in XML format.

  B. The replicate must be a mastered replicate.

  C. The conflict resolution rule must be always-apply.

  D. The WHERE clause in the participant definition must include a TimeSeries column.

  E. CDR_TSINSTANCEID configuration parameter must be set to the same value for every replication server.

  Correct Answer: BC