IBM Informix 11.70 System Administrator - C2090-919 Exam Questions [2026]

QUESTION NO: 1
Which sysmaster table can be queried to find the logging status of a database?

A. sysdatabases B. sysdblog C. sysdb D. sysdblogstatus

Correct Answer: A

QUESTION NO: 2
Which statement about temporary dbspaces is FALSE?

A. Temporary dbspaces are not backed up. B. A raw table can be created in a temporary dbspace. C. Tables stored in temporary dbspaces are not logged. D. Temporary dbspaces can have non-default page sizes.

Correct Answer: B

QUESTION NO: 3
What two conditions must be met in order to use Kernel-asynchronous I/O (KAIO)? (Choose two.)

A. When the operating system supports it. B. When the I/O is to raw disk space. C. When the KAIOON parameter in ONCONFIG file is set to 1. D. When the I/O is to buffered file chunks. E. When AIO is not available.

Correct Answer: A,B

QUESTION NO: 4
How can ER onconfig parameters be modified dynamically?

A. cdr set onconfig B. cdr tune onconfig C. cdr change onconfig D. cdr define onconfig

Correct Answer: C

QUESTION NO: 5
Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based on remaining free space?

A. SP_AUTOGROW B. SP_AUTOEXPAND C. SP_THRESHOLD D. SP_CHUNKEXTEND

Correct Answer: C

QUESTION NO: 6
Which is NOT valid information in the SQLHOSTS connectivity file (or on windows the SQLHOSTS registry key)?

A. Host name and service name. B. Number of listener threads. C. Connection type. D. Database server name or alias.

Correct Answer: B

QUESTION NO: 7
What two parameters can affect how often checkpoints occur? (Choose two.)

A. PHYSFILE B. BAR_PROGRESS_FREQ C. LOGSIZE D. LTAPEDEV E. BUFFERPOOL

Correct Answer: A,C