IBM C2090-919 - Informix 11.70 System Administrator Exam
Page: 3 / 25
Total 123 questions
Question #11 (Topic: Topic 1)
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
Answer: D
Question #12 (Topic: Topic 1)
Given the following SQL statement:
[IBM-C2090-919-6.0/IBM-C2090-919-7_2.png]
What does the merge statement do?
[IBM-C2090-919-6.0/IBM-C2090-919-7_2.png]
What does the merge statement do?
A. For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values.
B. For the rows that match the condition col1 = c1, it adds the the c2 column value to the col2 column value and updates corresponding rows in tab1.
C. For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2.
D. Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of corresponding rows in tab1.
Answer: B
Question #13 (Topic: Topic 1)
Given the following SQL command where the DBSPACETEMP onconfig and environment
variables are set to valid dbspaces:
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
variables are set to valid dbspaces:
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
A. DBSPACETEMP environment variable, root dbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.
B. DBSPACETEMP environment variable, DBSPACETEMP onconfig parameter, dbspace where the database was created, root dbspace.
C. DBSPACETEMP onconfig parameter variable, DBSPACETEMP environment variable, root dbspace, dbspace where the database was created.
D. DBSPACETEMP onconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.
Answer: B
Question #14 (Topic: Topic 1)
What two conditions must be met in order to use Kernel-asynchronous I/O (KAIO)?
(Choose two.)
(Choose two.)
A. When AIO is not available.
B. When the I/O is to raw disk space.
C. When the I/O is to buffered file chunks.
D. When the operating system supports it.
E. When the KAIOON parameter in ONCONFIG file is set to 1.
Answer: B,D
Question #15 (Topic: Topic 1)
What two onconfig parameters will help improve performance of new network connections?
(Choose two.)
(Choose two.)
A. NETTYPE
B. VPCLASS
C. NS_CACHE
D. FET_BUF_SIZE
E. NUMFDSERVERS
Answer: C,E
