IBM 000-619 Actual Free Exam Questions & Community Discussion

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: May 29, 2026

Question #33

Which action can be taken if an instance is down?

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

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

C. A point-in-time mixed restore.

D. Warm restore of non-critical storage spaces.

Discussion 0

Correct Answer: C Vote an answer

Question #34

Which two logging modes are compatible between two databases participating in a distributed query? (Choose two.)

A. Buffered and Non-logging

B. Non-logging and Non-logging

C. Non-logging and Unbuffered

D. ANSI and non-ANSI

E. Buffered and Unbuffered

Discussion 0

Correct Answer: B,E Vote an answer

Question #35

Which two statements are true? (Choose two.)

A. Having too little log space does not affect performance.

B. Simple large objects in blobspaces are not logged and they are included in the log backup in which the object was created.

C. Having too much log space does not affect performance.

D. Simple large objects in blobspaces are not logged and they are not included in the log backup in which the object was created.

E. Logical log files must always reside in rootdbs.

Discussion 0

Correct Answer: B,C Vote an answer

Question #36

store1, store2, store3 and store4 are defined as four servers participating in a GRID.

Which statement is true?

A. The SELECT query will return results from store3 and store4.

B. The SELECT query is not a GRID query.

C. The SELECT query will return results from all grid servers.

D. The SELECT query will return results from store1 and store2.

Discussion 0

Correct Answer: A Vote an answer

Question #37

Which option is available through ifx_grid_connect()?

A. Enable automatic creation of templates in a grid.

B. Defer propagation of DDL statements to other servers in the grid.

C. Enable use of TimeSeries columns in tables.

D. Rename a replicated database.

Discussion 0

Correct Answer: B Vote an answer

Question #38

Which statement accurately describes the mapped user functionality in Informix?

A. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessary privileges.

B. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the host computer.

C. The DBSA can control the access to the database at the table level by creating different security labels for each user.

D. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authentication mechanisms for each user.

Discussion 0

Correct Answer: B Vote an answer

Question #39

You need to create a new role for users on stores database. Which system catalog table can be checked to ensure the uniqueness of the new role name?

A. sysuser:sysroleauth

B. sysmaster:sysroles

C. sysmaster:sysusers

D. stores:sysusers

Discussion 0

Correct Answer: D Vote an answer

Question #40

Which SQL statement is used to remove detailed statistical information from the sysdistrib catalog table?

A. UPDATE STATISTICS DISTRIBUTIONS ONLY

B. UPDATE STATISTICS MEDIUM REMOVE DISTRIBUTIONS

C. UPDATE STATISTICS LOW DROP DISTRIBUTIONS

D. UPDATE STATISTICS LOW REMOVE DISTRIBUTIONS

Discussion 0

Correct Answer: C 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.