IBM A2090-556 Actual Free Exam Questions & Community Discussion

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

Exam Questions: 115
Updated On: May 31, 2026

Question #21

Which of the following statements about indexes is NOT true?

A. It is possible to create an index based on the output of a VARIANT function.

B. It is possible to create an index with a different fragmentation strategy than the table it is based upon.

C. It is possible to create an index with a different access method than the default one.

D. It is possible to create an index with a different ordering than the default one.

Discussion 0

Correct Answer: A Vote an answer

Question #22

What is the EXECUTE IMMEDIATE statement used for?

A. To return a result set immediately from the statement.

B. To dynamically execute a SELECT statement.

C. To execute a particular SQL statement with a higher priority.

D. To execute dynamically composed SQL statements.

Discussion 0

Correct Answer: D Vote an answer

Question #23

Which statement is NOT a characteristic of a sequence?

A. It specifies a negative value.

B. Rolling back a generated value is not allowed.

C. It has a lower level of concurrency than a serial column.

D. It specifies an initial value.

Discussion 0

Correct Answer: C Vote an answer

Question #24

Which of the following data types can be directly cast to a DATE type?

A. SMALLINT

B. DATETIME

C. DECIMAL

D. SMALLFLOAT

Discussion 0

Correct Answer: A Vote an answer

Question #25

Which statement about the ALIGNMENT modifier in the CREATE OPAQUE TYPE statement is correct?

A. If you do not include the ALIGNMENT modifier, the default alignment is a 4-byte boundary.

B. If you do not include the ALIGNMENT modifier, the default alignment is a 8-byte boundary.

C. If you do not include the ALIGNMENT modifier, the default alignment is a 1-byte boundary.

D. If you do not include the ALIGNMENT modifier, the default alignment is a 2-byte boundary.

Discussion 0

Correct Answer: A Vote an answer

Question #26

Assume a three level hierarchy of table inheritance, with table supertable as the parent, subtable as the child and subsubtable as the grandchild. How would you disable DELETE trigger delst_trg1 inherited from supertable at the subtable level only?

A. SET TRIGGER subtable.delst_trg1 DISABLED;

B. DROP TRIGGER delst_trg1;

C. SET TRIGGER delst_trg1 FOR subtable DISABLED;

D. DROP TRIGGER subtables.delst_trg1;

Discussion 0

Correct Answer: C Vote an answer

Question #27

Which two built-in data types store purely numeric integral values between -(2 63 -1) and 2 63 -1? (Choose two.)

A. SMALLINT

B. FLOAT

C. INT8

D. LONG

E. BIGINT

Discussion 0

Correct Answer: C,E Vote an answer

Question #28

Dynamic SQL allows a program to form an SQL statement during execution, so that user input determines the contents of the statement. What is the sequence of steps the program should follow to perform this action?

A. Assemble the text of the SQL statement, execute a PREPARE statement, and execute the prepared statement using the EXECUTE statement.

B. Execute a PREPARE statement, assemble the text of the SQL statement, and execute the prepared statement using the EXECUTE statement.

C. Assemble the text of the SQL statement and execute the statement using the EXECUTE statement.

D. Execute a PREPARE statement and execute the prepared statement using the EXECUTE statement.

Discussion 0

Correct Answer: A Vote an answer

Question #29

Which data type's internal structure is inaccessible to the database server?

A. ROW Unnamed

B. SET

C. ROW Named

D. Opaque

Discussion 0

Correct Answer: D Vote an answer

Question #30

What are all the possible table level privileges granted to user John on table ACCOUNT after the following statement is executed?
GRANT ALL ON ACCOUNT TO JOHN;

A. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, RENAME

B. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, UNDER

C. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, DROP

D. SELECT, UPDATE, INSERT, DELETE, INDEX, REFERENCES, ALTER, RENAME, DROP

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM A2090-556 Demo

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