IBM C2090-545 dumps - 100% Pass Guarantee!

Which SQL procedure declaration is coded correctly?

A. CREATE PROCEDURE myproc(IN salary DOUBLE, OUT commission DOUBLE) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION SETcommission = 0; DECLARE my_cur CURSOR FOR SELECT * FROM employee; DECLARE a DOUBLE; 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 a DOUBLE; DECLARE EXIT HANDLER FOR SQLEXCEPTION SETcommission = 0; DECLARE my_cur CURSOR FOR SELECT * FROM employee; SET a = .06 * salary; SET commission = a; END

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

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 evaluated before each iteration of the loop.

C. FOR statements have a terminating condition clause.

D. FOR statements are used to iterate over rows in a defined read-only result set.

Which two statements are true? (Choose two.)

A. SQL procedures can contain static and/or dynamic SQL statements.

B. Static or dynamic SQL execution is not associated with a package.

C. The SQL procedure isalways associated with a package that contains access paths of SQL statements in the procedure.

D. It is necessary for an end-user to have object level privileges if that user has execute privileges on an associated package and the SQL procedure.

E. SQL procedures can have COMMIT or ROLLBACK within atomic compound statements.

Given the following statements in an SQL procedure:

Which of the following assignment statements is valid?

A. SET c1 = VALUES (1, 2, 3);

B. SET c1 = CURSOR FOR VALUES (1, 2, 3);

C. c1 = CURSOR VALUES (1, 2, 3);

D. SET VALUES (1, 2, 3)for CURSOR c1;

Inthe given text below:

What will be the value of the output variable BONUS?

A. 500

B. 1000

C. 5200

D. 5500