IBM Assessment: DB2 9.7 SQL Procedure Developer - A2090-545 Free Exam Questions

A. All employees will receive at least a 5% salary increase.

B. An employee with a rating of 3 receives no salary increase.

C. An employee with a rating of 1 receives a 10% salary increase.

D. An employee with a rating of 2 receives a 3% salary increase.

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

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

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

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

A. SELECT and UPDATE privilege on the EMPLOYEE table

B. SYSMAINT authority

C. SYSCTRL authority

D. SELECT and ALTER privilege on the EMPLOYEE table

A. DB2 for LUW, DB2 for z/OS, SQL Server

B. DB2 for LUW, DB2 for z/OS, Sybase

C. DB2 for LUW, DB2 for z/OS, MySQL

D. DB2 for LUW, DB2 for z/OS, Oracle

A. salary * 1.03

B. salary * 1.10

C. salary * 1.05

D. salary * 1.50

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.

A. UPDATE SPECIAL REGISTER SCHEMA = 'DB2ADMIN'

B. UPDATE SPECIAL REGISTER TIME = ?2:30:00?UPDATE SPECIAL REGISTER TIME = ?2:30:00

C. SET CURRENT SCHEMA = 'DB2ADMIN'

D. SET CURRENT TIME = ?2:30:00?SET CURRENT TIME = ?2:30:00

A. DECLARE v_money MONEY;

B. DECLARE v_money CURRENCY;

C. DECLARE v_money DECIMAL(9,2);

D. DECLARE v_money DOUBLE;

A. 0

B. 1

C. 3

D. 2