Free IBM A2090-556 Exam Dumps Questions & Answers


Exam Code/Number:	A2090-556Join the discussion
Exam Name:	Assessment: Informix 11.50 Application Developer
Certification:	IBM
Free Question Number:	115
Publish Date:	Jul 17, 2026
# of views:	2017
Rating 100%

Page: 1 / 23
Total 115 questions

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.All users.
B.Any user with DBA privileges.
C.The user informix.
D.Any user in the DBA group.
E.Any user in the DBSECADM group.

Question 2

Which of the following may NOT be done with Informix SPL functions?

A.Execute dynamic SQL inside the function.
B.Used as a function in the create index statement.
C.Declare two functions with the same name.
D.SQL Optimizer directives inside stored procedures.

Question 3

Given the attached exhibit, what value does Mary see for their savings account?

A.200
B.0
C.-100
D.100

Question 4

When using the MQ Datablade Module, which interface binds tables to Websphere MQ queues, creating transparent access to WMQ objects and enabling users to access the queue as if it were a table?

A.External Tables
B.Virtual Tables
C.SQL Extensions
D.Datablade API

Question 5

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.COMMITTED READ
B.CURSOR STABILITY
C.REPEATABLE READ
D.DIRTY READ