IBM C2090-545 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-545
Exam Name/Title: DB2 9.7 SQL Procedure Developer
Certification Provider: IBM
Corresponding Certification: IBM Specialist

Exam Questions: 115
Updated On: May 28, 2026

Question #19

Which statement is TRUE about associative arrays?

A. Associative array cannot be a type of a table column.

B. The index values for an associative array must be a continuous set of integer values.

C. Associative array values can be stored in table columns.

D. The index data type for an associated array must be an integer.

Discussion 0

Correct Answer: A Vote an answer

Question #20

Which two statements are true about SQL procedures? (Choose 2)

A. SQL procedures cannot be called from triggers.

B. SQL procedures reside outside of the database for easy portability.

C. SQL procedures support the PRINT statement.

D. SQL procedures support recursion.

E. SQL procedures may return multiple result sets to the caller or to a client application.

Discussion 0

Correct Answer: D,E Vote an answer

Question #21

Given the function shown below:

Which statement will execute successfully?

A. SELECT to_upper('Seize the day!') FROM SYSIBM.SYSDUMMY1;

B. SELECT to_upper('Seize the day!')

C. SELECT * FROM TABLE(to_upper_fcn('Seize the day!')) AS T

D. SELECT * FROM to_upper_fcn('Seize the day!')

Discussion 0

Correct Answer: A Vote an answer

Question #22

Click the Exhibit button.

Given the user-defined function shown in the exhibit, what will the function return if invoked using the statement shown below?
SELECT check_id(1) FROM SYSIBM.SYSDUMMY1

A. SQLSTATE 80000 will be returned, with the custom error message "Error: ID 1 is not valid"

B. NULL

C. Error: ID 1 is not valid

D. Application Error

Discussion 0

Correct Answer: B Vote an answer

Question #23

Which object is used to return a result set from an SQL procedure?

A. Temporary table

B. Array

C. Cursor

D. Scratchpad

Discussion 0

Correct Answer: C Vote an answer

Question #24

Which statement is permitted within a scalar user-defined function body?

A. SIGNAL

B. LOOP

C. COMMIT

D. INSERT

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM C2090-545 Demo

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