IBM C2090-619 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-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 09, 2026

Question #19

Where must the HA_FOC_ORDER configuration parameter be set?

A. Any server in the cluster.

B. The HDR secondary only.

C. The SDS secondary only.

D. The primary server only.

Discussion 0

Correct Answer: D Vote an answer

Question #20

An Enterprise Replication server is a primary server for shared-disk secondary servers.
The DBA wants to reduce the replication latency by reducing the number of transactions that are applied before the logs are flushed to disk. What configuration parameter should the DBA modify?

A. CDR_LOG_LAG_ACTION

B. CDR_TSINSTANCEID

C. CDR_MAX_FLUSH_SIZE

D. CDR_MAX_TXNS

Discussion 0

Correct Answer: C Vote an answer

Question #21

Which of configuration parameter can be increased to improve the performance of flushing dirty buffer pages during checkpoints?

A. SHMVIRTSIZE

B. RA_PAGES

C. CLEANERS

D. CKPTINTVL

Discussion 0

Correct Answer: C Vote an answer

Question #22

Which threshold setting applies when configuring automatic memory management?

A. BUFFERPOOL

B. DS_TOTAL_MEMORY

C. SHMVIRTSIZE

D. SHMTOTAL

Discussion 0

Correct Answer: D Vote an answer

Question #23

What is the purpose of the GRANT ADMIN privilege?

A. Grants the admin privilege to use the Open Admin Tool.

B. Grants the admin privilege to perform DBSA functions.

C. Grants the admin privilege to run SQL administration API commands.

D. Grants the admin privilege to create role separation.

Discussion 0

Correct Answer: C Vote an answer

Question #24

How do the MAX_PDQPRIORITY onconfig parameter and the PDQPRIORITY environment variable work together to constrain access to PDQ resources?

A. MAX_PDQPRIORITY is the only constraint.

B. The constraint is MAX_PDQPRIORITY / 100 * PDQPRIORITY / 100.

C. The minimum of the two values is the actual constraint.

D. PDQPRIORITY is the only constraint.

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM C2090-619 Demo

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