IBM Informix 11.70 System Administrator - 000-919 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Which would provide the greatest performance benefit in a warehousing environment?

A. Large number of bufferpool buffers. B. Short checkpoint durations. C. Indexes on searched data. D. Optimize decision support memory.

Discussion 0

Correct Answer: D Vote an answer

Question 2

What statement about users accessing a Flexible Grid is true?

A. Only user informix can execute commands on a Flexible Grid. B. Every user can execute commands on the 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.

Discussion 0

Correct Answer: C Vote an answer

Question 3

Assuming the DBSPACETEMP onconfig and environment variables are set to valid dbspace names, where is the first location the instance will attempt to create a temporary non logged table?

A. The dbspace the database was created in. B. rootdbs. C. One of the dbspaces listed in the DBSPACETEMP configuration parameter. D. One of the dbspaces listed in the DBSPACETEMP environment variable.

Discussion 0

Correct Answer: D Vote an answer

Question 4

What two conditions must be met for direct I/O to occur? (Choose two.)

A. When the I/O is to cooked disk space. B. When the table is too big to fit in the bufferpool. C. When doing I/O operations on temporary dbspaces. D. When the DIRECT_IO configuration parameter is set to 1. E. When the I/O is to raw disk space.

Discussion 0

Correct Answer: A,D Vote an answer

Question 5

Identify a scenario when you CANNOT use in-place migration?

A. When you want to change database locale. B. When you want to use new configuration features in the new Informix version. C. When you want to migrate from a 32-bit to a 64-bit port of Informix. D. When you want to defragment some of the heavily fragmented tables.

Discussion 0

Correct Answer: A Vote an answer

Question 6

Given the two indexes defined on table tab1:

Which optimization method may be used?

A. OUTER_INDEX B. INDEX_SELFJOIN C. STAR_JOIN D. MULTI_INDEX

Discussion 0

Correct Answer: D Vote an answer

Question 7

Without explicitly setting DBSPACETEMP and TEMPTABLE_NOLOG, where will temporary tables be created by default? (Choose three.)

A. The dbspace in which the active database was created. B. The $INFORMIXDIR/tmp directory. C. The /tmp directory or PSORT_DBTEMP. D. The users' home directory. E. The root dbspace.

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 8

Most, but not all Virtual Processors, can be modified via the onmode -p command. Which CANNOT be modified?

A. BTS B. CSM C. ADM D. CPU

Discussion 0

Correct Answer: C Vote an answer