IBM A2090-619 Actual Free Exam Questions & Community Discussion

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

Exam Questions: 130
Updated On: Jun 15, 2026

Question #25

Which command would you use to export and import backup object metadata from one database server to another in conjunction with Primary Storage Manager?

A. dbexport

B. ontape -exp

C. onsmsync

D. onbar -E

Discussion 0

Correct Answer: C Vote an answer

Question #26

The total number of locks allocated equals the value specified by the LOCKS configuration parameter. What is the behavior of the database server when more locks are now requested?

A. The user encounters a lock request error.

B. More memory is allocated for additional lock structures in the VIRTUAL section of shared memory.

C. More memory is allocated for additional lock structures from DS_TOTAL_MEMORY.

D. More memory is allocated for additional lock structures in the RESIDENT section of shared memory.

Discussion 0

Correct Answer: B Vote an answer

Question #27

What data migration tool(s) should be used to load data from a non-Informix data source?

A. onload and High Performance Loader

B. onload and dbload

C. dbload and High Performance Loader

D. dbimport

Discussion 0

Correct Answer: C Vote an answer

Question #28

Several operating-system kernel configuration parameters can affect the use of shared memory by the database server. Which two kernel parameters may need to be configured?
(Choose two.)

A. Memory page size.

B. Maximum operating-system shared-memory segment size.

C. Total number of available semaphores.

D. Total memory presented to the operating system.

E. Lower-boundary address for shared memory.

Discussion 0

Correct Answer: B,E Vote an answer

Question #29

Which is NOT a component of the IBM Mobile Database offering?

A. IBM InfoSphere Warehouse

B. IBM solidDB

C. IBM Informix

D. IBM DB2

Discussion 0

Correct Answer: A Vote an answer

Question #30

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 #31

When using the deployment assistant, which two statements are true? (Choose two.)

A. The user must have connect privilege to sysadmin database.

B. A java environment must be configured.

C. The user must have connect permission to all databases.

D. Chunks can be raw devices or buffered files.

E. The Informix user account must be used.

Discussion 0

Correct Answer: A,B Vote an answer

Question #32

Which statement accurately describes the selective row-level auditing feature in Informix?

A. Auditing can be configured so that row-level events of only selected views are recorded in the audit trail.

B. Auditing can be configured so that events of only selected rows within a table are recorded in the audit trail.

C. Auditing can be configured so that row-level events of only selected partitions are recorded in the audit trail.

D. Auditing can be configured so that row-level events of only selected tables are recorded in the audit trail.

Discussion 0

Correct Answer: D Vote an answer

Download Free IBM A2090-619 Demo

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