Free IBM A2090-919 Practice Test & Real Exam Questions

Exam Code/Number: A2090-919
Exam Name/Title: Assessment: System Administrator for Informix Server 11.70
Certification Provider: IBM
Corresponding Certification: Certified Administrator

Exam Questions: 123
Updated On: May 26, 2026

Question #1

Given the following SQL statement:

What does the merge statement do?

A. For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2.

B. Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of corresponding rows in tab1.

C. For the rows that match the condition col1 = c1, it adds the the c2 column value to the col2 column value and updates corresponding rows in tab1.

D. For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values.

Discussion 0

Correct Answer: C Vote an answer

Question #2

Which role can create, alter, or delete trusted context objects?

A. DBA

B. DBSA

C. DBSECADM

D. DBSSO

Discussion 0

Correct Answer: C Vote an answer

Question #3

What does the following SQL statement do? execute function task("reset sysadmin", "admindbs");

A. Renames sysadmin database to admindbs.

B. Turns the whole Database Scheduler off and finally drops sysadmin database.

C. Locks sysadmin database in exclusive mode and recreates it in dbspace admindbs.

D. Purges all "mon_*" tables in sysadmin database as user admindbs.

Discussion 0

Correct Answer: C Vote an answer

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

Question #4

A storage pool entry can be used to do what?

A. Increase the size of the physical log.

B. Increase the size of a storage space.

C. Increase the size of a chunk.

D. Increase the size of the logical logs.

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which of the following gives a good initial estimate for the physical log size?

A. 110% the default buffer pool.

B. 110% of rootdbs.

C. 110% of combined buffer pool.

D. 110% of the logical log space.

Discussion 0

Correct Answer: C Vote an answer

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

Question #6

Which parameter is used to configure the servers in a high-availability cluster so that transactions complete after failover?

A. FAILOVER_TX_TIMEOUT

B. FAILOVER_CALLBACK

C. SURVIVAL_TX_TIMEOUT

D. SURVIVAL_TX_ENABLE

Discussion 0

Correct Answer: A Vote an answer

Question #7

Which $ONCONFIG parameter must be set enable parallel OnBar backup operations?

A. BAR_NB_XPORT_COUNT

B. BAR_MAX_BACKUP

C. BAR_SIZE_FACTOR

D. BAR_PERFORMANCE

Discussion 0

Correct Answer: B Vote an answer

Question #8

Which statement about mapped user functionality is true?

A. The DBSA can control the access to tables at a row level using security labels.

B. Mapped users cannot execute distributed operations.

C. The DBSA can grant database server access to externally authenticated users with no local account.

D. Mapped users are allowed to run with multiple names.

Discussion 0

Correct Answer: C Vote an answer

Question #9

Which two corrective actions may be taken if following message is logged in the online message log during a failed attempt to bring an instance online? (Choose two)
18:15:44
Size of resident + virtual segments 100000KB + 60000KB > 150000KB
18:15:44
total allowed by configuration parameter SHMTOTAL

A. Increase SHMVIRTSIZE

B. Decrease buffer pool size

C. Increase SHMTOTAL

D. Decrease SHMBASE

E. Decrease SHMADD

Discussion 0

Correct Answer: B,C Vote an answer

Download Free IBM A2090-919 Demo

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