IBM IBM Certified System Administrator A2090-619 Questions & Answers

• Question 121:

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

  Which type of device does Primary Storage Manager support?

  A. File

  B. Tape

  C. Directory

  D. Named pipe

  Correct Answer: A

• Question 123:

  Which two statements are true about blobspace? (Choose two.)

  A. The TEXT or BYTE objects are stored in the logical log files.

  B. A blobspace is a logical storage unit that stores only TEXT and BYTE data.

  C. The TEXT or BYTE objects that are assigned to a blobspace are physically logged.

  D. A newly created blobspace is immediately available for storage of TEXT or BYTE data.

  E. The database server writes data stored in a blobspace directly to disk without passing it through the bufferpool.

  Correct Answer: BE

• Question 124:

  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

• Question 125:

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

  What command unlocks the storage catalogs when using the Primary Storage Manager?

  A. onbar -d unlock

  B. onpsm -C unlock

  C. onmode -C unlock

  D. onsmsync -c unlock

  Correct Answer: B

• Question 127:

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

  An Informix server is configured with multiple CPU VPs and poll threads and is experiencing NSF lock errors. What action should be taken to reduce the network shared file lock contention?

  A. Increase the value of MAX_INCOMPLETE_CONNECTIONS.

  B. Increase the value of NUMFDSERVERS and add more poll threads.

  C. Increase the value of NUMFDSERVERS and increase the number of MSC VPs.

  D. Increase the network buffer pool using the IFX_NETBUF_PVTPOOL_SIZE environment variable.

  Correct Answer: B

• Question 129:

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

  You have started a violations table for a target table with a non default name. (For example: "START VIOLATIONS TABLE FOR customer USING exceptions, reasons;"). How can you determine the relationship between the violations table and the target table later?

  A. Using dbschema utility

  B. Using 'oncheck -pT' command

  C. Querying sysdepends system catalog table

  D. Querying sysviolations system catalog table

  Correct Answer: D