Free IBM C2090-556 Practice Test & Real Exam Questions

Exam Code/Number: C2090-556
Exam Name/Title: Informix 11.50 Application Developer
Certification Provider: IBM
Corresponding Certification: On Demand Business

Exam Questions: 115
Updated On: May 30, 2026

Question #1

To register a routine in the database, an authorized user wraps the SPL commands in a CREATE FUNCTION or CREATE PROCEDURE statement. The database server stores a registered SPL routine internally. Which two of the following can register a new routine in the database? (Choose two.)

A. The user informix.

B. Any user in the DBSECADM group.

C. All users.

D. Any user with DBA privileges.

E. Any user in the DBA group.

Discussion 0

Correct Answer: A,D Vote an answer

Question #2

What result will be returned for User B in the attached exhibit?

A. A "row locked" error.

B. An account_balance of 80.

C. An account_balance of either 80 or 90 depending on when buffers were last flushed to disk.

D. An account_balance of 90.

Discussion 0

Correct Answer: A Vote an answer

Question #3

Which type of isolation level results in a lock on every row a query examines in order to retrieve any row from the result set?

A. CURSOR STABILITY

B. DIRTY READ

C. COMMITTED READ

D. REPEATABLE READ

Discussion 0

Correct Answer: D Vote an answer

Question #4

When using IBM Data Server Driver for JDBC to connect to Informix Server, which URL should be used when making a connection using Distributed Relational Database Architecture protocol?

A. "jdbc:drda://hostname1:5021/storesdb:user=XXX;password=YYY"

B. "jdbc:informixsqli://hostname1:5021/storesdb:INFORMIXSERVER=myserver;user=XXX;password=YYY"

C. "jdbc:ids://hostname1:5021/storesdb:user=XXX;password=YYY"

D. "jdbc:db2j:net://hostname1:5021/storesdb:user=XXX;password=YYY"

Discussion 0

Correct Answer: C Vote an answer

Question #5

Which cast is supported within expressions?

A. Column

B. Constructor

C. Conditional

D. Aggregate

Discussion 0

Correct Answer: A Vote an answer

Question #6

What type of cursor would allow uninterrupted access to a set of rows across multiple transactions?

A. Hold

B. Fetch

C. Scroll

D. Persistent

Discussion 0

Correct Answer: A Vote an answer

Question #7

Which statement describes a select cursor?

A. It is the representation of columns or values that a user-defined function returns after a SELECT statement.

B. It is used when you associate an EXECUTE FUNCTION statement with a cursor.

C. It is a data structure that represents the active set of rows that the SELECT statement retrieved.

D. It is a cursor that uses the FETCH option to retrieve successive rows of data from another cursor.

Discussion 0

Correct Answer: C Vote an answer

Download Free IBM C2090-556 Demo

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