IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545 Exam Questions [2026]

QUESTION NO: 1
Which of the following can be done while debugging a SQL procedure with IBM Data Studio?

A. Re-execute the current statement. B. Edit the procedure and continue. C. Change the order of statements being executed. D. Change the value of any variables used.

Correct Answer: D

QUESTION NO: 2
Click the Exhibit button.

The table and triggers in the exhibit have been created successfully, when the statements shown below are executed.
INSERT INTO emp_hours VALUES('KAY', '9:00', '17:00');
INSERT INTO emp_hours (emp_name, starting) VALUES('BILL', '9:00');
What is the result?

A. Table EMP_HOURS will contain this row: BILL 9:00:00 AM 17:00:00 PM B. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM 10:00:00 AM C. Table EMP_HOURS will contain these rows: KAY 9:00:00 AM 5:00:00 PM BILL 9:00:00 AM D. Table EMP_HOURS will contain this row: BILL 9:00:00 AM

Correct Answer: B

QUESTION NO: 3
Given the function:

What is the output of the statement: VALUES LENGTH(fcn1(' one good day '))?

A. 14 B. ' one good day ' C. 12 D. 'one good day'

Correct Answer: C

QUESTION NO: 4
Which two statements are true with regards to nesting SQL procedures? (Choose two.)

A. An SQL procedure cannot invoke procedures built in other languages (e.g., C, Java). B. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the READS SQL DATA clause. C. An SQL procedure can invoke the same SQL procedure more than once. D. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL clause. E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the MODIFIES SQL DATA clause.

Correct Answer: C,D

QUESTION NO: 5
How is the FOR statement distinct from other conditional statements?

A. FOR statements are evaluated at the completion of each iteration of the loop. B. FOR statements are used to iterate over rows in a defined read-only result set. C. FOR statements are evaluated before each iteration of the loop. D. FOR statements have a terminating condition clause.

Correct Answer: B

QUESTION NO: 6
Which of the following statements is true?

A. A TIMESTAMP value can be assigned to a TIME variable. B. The result of a GET DIAGNOSTICS statement cannot be assigned to a variable. C. Values cannot be assigned to variables inside ERROR HANDLERS. D. A DATETIME value can be assigned to a DATE variable.

Correct Answer: A

QUESTION NO: 7
Which statement will let you use the result set from the nested procedure CALLEE?

A. BIND RESULT SET WITH PARAMETERS FOR PROCEDURE callee; B. ASSOCIATE RESULT SET LOCATOR( loc1) WITH PROCEDURE callee; C. SELECT * FROM callee; D. INSERT RESULT SET FROM callee INTO CURSOR c1;

Correct Answer: B

QUESTION NO: 8
The CREATE OR REPLACE PROCEDURE statement is similar semantically to which of the following combined statements?

A. DROP and CREATE PROCEDURE B. DROP and ALTER PROCEDURE C. UPDATE and CREATE PROCEDURE D. ALTER and CREATE PROCEDURE

Correct Answer: A