A2090-545問題集、IBM実際の試験問題

質問 1

Given the variable declaration shown below: DECLARE v_mydate DATE; Which statement will assign a value to the variable V_MYDATE?

A. SELECT CURRENT TIMESTAMP INTO v_mydate FROM SYSIBM.SYSDUMMY1;

B. VALUES (08262010) INTO v_mydate;

C. SELECT CURRENT DATE INTO v_mydate FROM SYSIBM.SYSDUMMY1;

D. VALUES CURRENT TIMESTAMP INTO v_mydate;

正解: C

質問 2

Which code fragment illustrates the proper way to perform error checking in SQL stored procedures?

A. ...
IF
EXCEPTION < 0
ELSE THEN;
NULL;
ENDIF;
...

B. ...
BEGIN
EXCEPTION < 0
ELSE;
NULL;
END;
...

C. ... BEGIN IF SQLCODE < 0 THEN RETURN -6786 END;

D. ...
IF SQLCODE < 0 THEN
RETURN -6786;
END IF;
...

正解: D

質問 3

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; exit the procedure without closing the cursor.

B. 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.

C. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; code a SELECT statement in the procedure body.

D. 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.

正解: D

質問 4

Given the following statements: In the above given procedure, the statement in which line is not valid?

A. 9

B. 1

C. 10

D. 7

正解: D

質問 5

What is the correct order for declarations in a compound statement defined by BEGIN and END?

A. variable, condition, cursor, handler

B. variable, cursor, handler, condition

C. variable, condition, handler, cursor

D. variable, cursor, condition, handler

正解: A

質問 6

Given the following script:

What would be result from the SELECT * FROM audi1?

A. NLEVEL MESSAGE 1 FROM TRIGGER

B. NLEVEL MESSAGE 2 FROM TRIGGER

C. NLEVEL MESSAGE
2 TEST1

D. NLEVEL MESSAGE
5 FROM TRIGGER

正解: B

質問 7

Which command can be used to optimize static SQL statements containing parameterized queries?

A. SET CURRENT EXPLAIN MODE=YES

B. SET CURRENT EXPLAIN MODE=EXPLAIN

C. SET CURRENT EXPLAIN MODE=PARAM

D. SET CURRENT EXPLAIN MODE=REOPT

正解: D

質問 8

Which SQL procedure declaration is coded correctly?

A. CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
BEGIN
DECLARE a DOUBLE;
DECLARE my_cur CURSOR FOR SELECT * FROM employee;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
SET commission = 0;
SET a = .06 * salary;
SET commission = a;
END

B. CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
SET commission = 0;
DECLARE a DOUBLE;
DECLARE my_cur CURSOR FOR SELECT * FROM employee;
SET a = .06 * salary;
SET commission = a;
END

C. CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
BEGIN
DECLARE EXIT HANDLER FOR SQLEXCEPTION
SET commission = 0;
DECLARE my_cur CURSOR FOR SELECT * FROM employee;
DECLARE a DOUBLE;
SET a = .06 * salary;
SET commission = a;
END

D. CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE)
BEGIN
DECLARE a DOUBLE;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
SET commission = 0;
DECLARE my_cur CURSOR FOR SELECT * FROM employee;
SET a = .06 * salary;
SET commission = a;
END

正解: A

質問 9

Which of the following statement is TRUE about a REPEAT loop?

A. The condition is checked at the end of the loop.

B. A REPEAT loop behaves like a WHILE loop.

C. The condition is checked at the beginning of the loop.

D. A REPEAT loop behaves like a FOR loop.

正解: A

IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545 模擬練習