Try IBM : A2090-545 practice torrent pass for sure

What values are generated each time an SQL statement is executed?

• A. EXCEPTION and SQLCODE
• B. SQLSTATE and SQLCODE
• C. SQLERRN and SQLMSG
• D. SQLSTATE and EXCEPTION

Given the following SQL:

Which statement is incorrect?

• A. The cursor declaration requires the WITH RETURN TO CALLER clause in order to return a result set.
• B. The procedure declaration requires the DYNAMIC RESULT SETS 1 clause in order to return a result set.
• C. The cursor declaration requires the WITH RETURN clause in order to return a result set.
• D. The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.

In the function shown below:

Which statement can be used to invoke the function above?

• A. SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
• B. SELECT * FROM fcn1('B01')
• C. SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1
• D. SELECT * FROM TABLE(fcn1('B01'))

Which SQL procedure declaration is coded correctly?

• A. 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
• B. 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
• C. 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
• D. 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

How is the FOR statement distinct from other conditional statements?

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