最新のA2090-545問題集で試験を準備する

IBM A2090-545 試験概要:

IBM A2090-545 試験シラバストピック:

IBM Assessment: DB2 9.7 SQL Procedure Developer 認定 A2090-545 試験問題：

問題 #1

Which statement can be used to declare a variable inside an SQL procedure that can be used to represent a monetary value?

A. DECLARE v_money MONEY;
B. DECLARE v_money DOUBLE;
C. DECLARE v_money CURRENCY;
D. DECLARE v_money DECIMAL(9,2);

問題 #2

Which statement describes what must be done to create an SQL procedure that returns a result set?

A. Execute the CREATE PROCEDURE statement using the defaults; declare a cursor within the procedure body; open the cursor; retrieve each row into output variables; close the cursor before exiting the procedure.
B. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; declare a cursor within the procedure body; open the cursor; exit the procedure without closing the cursor.
C. Execute the CREATE PROCEDURE statement using the defaults; declare a cursor within the procedure body; open the cursor; exit the procedure without closing the cursor.
D. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; code a SELECT statement in the procedure body.

問題 #3

Which statement will create global variable?

A. CREATE VARIABLE glob_emp_sal ANCHORE TO employee.salary
B. PUBLISH VARIABLE glob_emp_sal DECIMAL(9,2)
C. DECLARE GLOBAL VARIABLE glob_emp_sal ANCHORE TO employee.salary
D. DECLARE GLOBAL VARIABLE glob_emp_sal DECIMAL(9,2)

問題 #4

Which code fragment illustrates the proper way to capture and save SQL error handler values so they can be used to control procedure logic?

A. DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLERRN;
B. DECLARE ERROR HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = EXCEPTION;
C. DECLARE ERROR HANDLING FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;
D. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLCODE;

問題 #5

Given the procedure shown below:

How many rows will be inserted in the table?

A. 2
B. 1
C. 0
D. 3

解説：