IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 91:

  Click the Exhibit button.

  

  Which statement correctly describes the result of the FOR loop shown in the exhibit?

  A. FULLNAME isset to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial. Only the last value for FULLNAME is inserted into table TNAMES.
  B. FULLNAME is set to the last name of the employee, followed by a comma, thefirst name, a blank space, and the middle initial. Only the first value for FULLNAME is inserted into table TNAMES.
  C. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial for each row. Each value for FULLNAME is inserted into table TNAMES in alphabetical order.
  D. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial for each row. Each value for FULLNAME is insertedinto table TNAMES.
  D. FULLNAME is set to the last name of the employee, followed by a comma, the first name, a blank space, and the middle initial for each row. Each value for FULLNAME is insertedinto table TNAMES.

• Question 92:

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

• Question 93:

  Which statement correctly describes characteristics of external functions?

  A. External functions cannot return tables.
  B. All cursors opened within an external function should stay open until thedatabase is quiesced.
  C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.
  D. Transactions can be terminated within external functions.
  C. Scratchpads can be used to allocate dynamic memory required for multiple function invocations.

• Question 94:

  Given the function:

  

  What is the output of the statement: VALUES LENGTH(fcn1(' one good day '))?

  A. 'one good day'
  B. 12
  C. ' one good day '
  D. 14
  B. 12

• Question 95:

  Given the following code

  

  What would be value of parm2 if the following proc1 called as call proc1(3, ?)?

  B. 10
  C. 3
  D. 8
  B. 10

• Question 96:

  Which CREATE PROCEDURE statement option should be used if you plan on issuing a DECLARE GLOBAL TEMPORARY TABLE statement from within the SQL procedure body?

  A. CONTAINS SQL
  B. READS SQL DATA
  C. MODIFIES SQL DATA
  D. LANGUAGE SQL
  C. MODIFIES SQL DATA

• Question 97:

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

  A. 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.
  B. Specify the clause DYNAMIC RESULT SETS 1 in the CREATE PROCEDURE statement; code a SELECT statement in the procedure body.
  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. 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.
  A. 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.

• Question 98:

  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 DECIMAL(9,2);
  D. DECLARE v_money CURRENCY;
  C. DECLARE v_money DECIMAL(9,2);

• Question 99:

  When considering authorization for CREATE OR REPLACE PROCEDURE statements, the authorization id must have:

  A. DBADM authority
  B. group privileges on the table or view specified in the procedure
  C. IMPLICIT_SCHEMA authority on the database
  D. ownership of the existing procedure
  D. ownership of the existing procedure

• Question 100:

  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 CONTINUE HANDLERFOR SQLEXCEPTION, SQLWARNING, NOTFOUND SET retcode = SQLCODE;
  B. DECLARE ERROR HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = EXCEPTION;
  C. DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLERRN;
  D. DECLARE ERRORHANDLING FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;
  A. DECLARE CONTINUE HANDLERFOR SQLEXCEPTION, SQLWARNING, NOTFOUND SET retcode = SQLCODE;