Free IBM 000-556 Practice Test & Real Exam Questions

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

Exam Questions: 115
Updated On: Jun 03, 2026

Question #1

Which of the following data types is not based on built-in data types?

A. Row types

B. Named row types

C. Opaque types

D. Distinct types

Discussion 0

Correct Answer: C Vote an answer

Question #2

What is the correct sequence for retrieving multiple rows using a cursor for a dynamic SQL query?

A. DECLARE, OPEN, FETCH, FREE, CLOSE

B. DECLARE, FETCH, OPEN, CLOSE, FREE

C. OPEN, DECLARE, FETCH, CLOSE, FREE

D. DECLARE, OPEN, FETCH, CLOSE, FREE

Discussion 0

Correct Answer: D Vote an answer

Question #3

The definition of the table "tab1" is:
create table tab1 (colA boolean, colB boolean);
Which INSERT statement for the table is correct?

A. insert into tab1 (colA, colB) values (t,f);

B. insert into tab1 (colA, colB) values ('F','0');

C. insert into tab1 (colA, colB) values ('t', NULL);

D. insert into tab1 (colA, colB) values (1,0);

Discussion 0

Correct Answer: C Vote an answer

Question #4

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

Question #5

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

A. DECIMAL

B. SMALLFLOAT

C. DATETIME

D. SMALLINT

Discussion 0

Correct Answer: D Vote an answer

Question #6

Which URL syntax is NOT used for DRDA communications?

A. jdbc:db2

B. jdbc:informix

C. jdbc:db2j:net

D. jdbc:ids

Discussion 0

Correct Answer: B Vote an answer

Question #7

What is the syntax to query a table that resides on a remote Informix database?

A. database@server:[owner.]table

B. database@server:databasename:user:password:[owner.]table

C. database@server:databasename:[owner.]table

D. database@server:user:password:[owner.]table

Discussion 0

Correct Answer: A Vote an answer

Question #8

What format should be used to define columns using user-defined types in an ANSI-compliant database?

A. tablename.colname

B. owner.colname

C. owner.tablename.colname

D. colname

Discussion 0

Correct Answer: B Vote an answer

Question #9

When user "ABC" attempts to use a view, the database server tests for which of the following privileges?

A. The privileges granted to "ABC" for the view and the underlying tables.

B. The privileges granted to "ABC" for the view and not the underlying tables.

C. The privileges not granted to "ABC" for the view and the underlying tables.

D. The privileges granted to "ABC" to access the underlying tables and not the view.

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM 000-556 Demo

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