Which of the following steps are required to debug a stored procedure using IBM Data Studio?

• A. Debug the stored procedure from the Data Source Explorer.
• B. Deploy the stored procedure from the data development project, choose option for debugging and then debug.
• C. Debug the stored procedure from the IBM Data Studio command line console.
• D. Deploy the stored procedure from the data development project, debug the stored procedure.

A developer needs to create a user-defined function that will return a list of employees who work in a particular department. Which statement will successfully create a function that meets this objective?

• A. CREATE FUNCTION dept_employees (deptno CHAR(3)) RETURNS TABLE DYNAMIC RESULT SETS 1 LANGUAGE SQL READS SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
• B. CREATE FUNCTION dept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6), l_name VARCHAR(15), f_name VARCHAR(12)) LANGUAGE SQL READS SQL DATA RETURN SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept = dept_employees.deptno
• C. CREATE FUNCTION dept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6), l_name VARCHAR(15), f_name VARCHAR(12)) DYNAMIC RESULT SETS 1 LANGUAGE SQL READS SQL DATA DECLARE emp_info CURSOR WITH RETURN FOR SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
• D. CREATE FUNCTION dept_employees (deptno CHAR(3)) RETURNS TABLE LANGUAGE SQL READS SQL DATA RETURN SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept = dept_employees.deptno

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. READS SQL DATA
• B. CONTAINS SQL
• C. LANGUAGE SQL
• D. MODIFIES SQL DATA

Click the Exhibit button.

How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?

• A. 4
• B. 7
• C. 5
• D. 0

The cursor BASEINFO was defined as follow:

Which statement would be used to create a local variable named BASEINFOROW that can be used to store results from the BASEINFO cursor?

• A. CREATE VARIABLE baseinforow ASSOCIATED WITH baseinfo
• B. DEFINE ROW baseinforow FOR CURSOR baseinfo
• C. DECLARE baseinforow ANCHOR ROW baseinfo
• D. DECLARE ROW baseinforow ASSOCIATED WITH CURSOR baseinfo