Free IBM 000-619 Practice Test & Real Exam Questions

Exam Code/Number: 000-619
Exam Name/Title: IBM Informix 12.10 System Administrator
Certification Provider: IBM
Corresponding Certification: IBM Certified System Administrator

Exam Questions: 130
Updated On: Jun 16, 2026

Question #1

Which statement is FALSE regarding SBSPACES?

A. They have read, write, and seek properties similar to a standard UNIX file.

B. They do not obey transaction isolation modes.

C. Smart large objects within table rows are not required to be retrieved in one statement.

D. They are recoverable.

Discussion 0

Correct Answer: B Vote an answer

Question #2

Which command line utility does NOT have the equivalent functionality using the SQL
Administration API?

A. onspaces

B. oninit

C. onmode

D. onparams

Discussion 0

Correct Answer: B Vote an answer

Question #3

Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?

A. SP_WAITTIME

B. SP_AUTOEXPAND

C. SP_CHUNKEXTEND

D. SP_THRESHOLD

Discussion 0

Correct Answer: B Vote an answer

Question #4

Which two parameters must be set to a valid value before starting a Shared Disk (SD)
Secondary server? (Choose two.)

A. SDS_LOGCHECK

B. SDS_PAGING

C. SDS_TIMEOUT

D. SDS_TEMPDBS

E. SDS_ALTERNATE

Discussion 0

Correct Answer: B,D Vote an answer

Question #5

Which statement about Storage Provisioning is true?

A. Only cooked devices can be extended.

B. Mirrored and unmirrored spaces can be extended.

C. Only raw devices can be extended.

D. Only unmirrored spaces can be extended.

Discussion 0

Correct Answer: D Vote an answer

Question #6

Which statement describes the behavior of an Informix instance when the
IFX_EXTEND_ROLE configuration parameter is set to ON.

A. All users with the EXTEND role can register external routines.

B. All users can create external routines in the database server.

C. All users with the default role can register external routines.

D. All users with the EXTEND role can grant it to other users.

Discussion 0

Correct Answer: A Vote an answer

Question #7

Which two tasks can be performed through an Informix Grid? (Choose two.)

A. Copy external files to grid servers.

B. Setup replication automatically in a grid.

C. Modify replication server attributes for grid servers.

D. Install Informix products.

E. Start Informix servers in a grid.

Discussion 0

Correct Answer: A,B Vote an answer

Question #8

Which action can be taken if an instance is down?

A. Warm restore of non-critical storage spaces.

B. A point-in-time mixed restore.

C. A mixed restore using onbar whole system backup and incremental dbspace level backups.

D. Cold restore by onbar using storage space backups taken by ontape on tape devices.

Discussion 0

Correct Answer: B Vote an answer

Question #9

In addition to examining the Connection Manager log file, what are two ways to monitor the
Connection Manager status? (Choose two.)

A. oncmsm

B. onstat

C. onmode

D. onmonitor

E. OpenAdmin Tool

Discussion 0

Correct Answer: B,E Vote an answer

Question #10

Given the following statement: UPDATE STATISTICS LOW FOR TABLE customer
(customer_num); Which catalog table data is NOT updated?

A. sysdistrib

B. syscolumns

C. sysindexes

D. systables

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM 000-619 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM 000-619 exam.