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

QUESTION NO: 1
Which utility requires database logging be turned off to load a table?

A. dbimport B. load C. dbload D. onload

Correct Answer: D

QUESTION NO: 2
Fragment level statistics are NOT supported with which fragmentation strategy?

A. List fragmentation. B. Interval fragmentation. C. Expression fragmentation. D. Round-robin fragmentation.

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 3
How does the Deployment Assistant enable you to reduce the size of the installation to be deployed?

A. By removing specific product features. B. By limiting the size of dbspaces. C. By removing all free space at the end of a chunk. D. By removing specific databases.

Correct Answer: A

QUESTION NO: 4
Which would provide the greatest performance benefit in a warehousing environment?

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

Correct Answer: A

QUESTION NO: 5
Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?

A. To ensure the buffer pool is always available. B. To avoid LRU flushes. C. To avoid transaction blocking during checkpoints. D. To ensure the onstat -g ckp report is accurate.

Correct Answer: C

QUESTION NO: 6
Which two onconfig parameters can be set to backup/restore to/from a cloud storage location? (Choose two.)

A. LTAPEBLK B. BAR_BSALIB_PATH C. TAPEDEV D. LTAPEDEV E. TAPEBLK

Correct Answer: C,D

QUESTION NO: 7
Which statement about Informix data compression is true?

A. Compression operations can be executed on a HDR secondary, RS secondary, or SD secondary server. B. Compressing data on a primary instance will not compress data on the High-Availability Data Replication (HDR) secondary instance. C. Compressing data on one Enterprise Replication (ER) node affects the data on the other ER nodes. D. I/O-bound tables, for example, those with bad cache hit ratios, are good candidates for compression.

Correct Answer: D

QUESTION NO: 8
By default, the alarm program gets executed for which event(s)?

A. All events. B. Only for events with Severity code 1. C. Only for events with Severity code 5. D. Only for events with Severity code greater than 1.

Correct Answer: D

QUESTION NO: 9
Which of the following schema privileges allows you to rename a fragment?

A. ALTER B. MODIFY C. AMEND D. RENAME

Correct Answer: A

QUESTION NO: 10
On which node of an Informix H/A cluster can you execute an external backup without disturbing cluster operations?

A. Remote standalone secondary B. Primary C. Shared disk secondary D. High-availability data replication secondary

Correct Answer: A