IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 111:

  A developer needs to create a user-defined functionthat 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 LANGUAGE SQL READS SQL DATA RETURN SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept = dept_employees.deptno
  B. CREATE FUNCTION dept_employees (deptno CHAR(3)) RETURNS TABLE DYNAMIC RESULT SETS 1 LANGUAGE SQL READS SQL DATA DECLARE emp_info CURSOR WITHRETURN FOR SELECT empno, lastname AS l_name, firstnme AS f_name FROM employee WHERE employee.workdept = dept_employees.deptno OPEN emp_info; RETURN
  C. 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
  D. CREATE FUNCTION dept_employees (deptno CHAR(3)) RETURNS TABLE (empno CHAR(6), l_nameVARCHAR(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
  C. 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

• Question 112:

  Which statement will change the value of a special register?

  A. UPDATE SPECIAL REGISTER TIME = ?2:30:00?UPDATE SPECIAL REGISTER TIME = ?2:30:00
  B. UPDATE SPECIAL REGISTERSCHEMA = 'DB2ADMIN'
  C. SET CURRENT TIME = ?2:30:00?SET CURRENT TIME = ?2:30:00
  D. SET CURRENT SCHEMA = 'DB2ADMIN'
  D. SET CURRENT SCHEMA = 'DB2ADMIN'

• Question 113:

  Click the Exhibit button.

  

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

  B. 4
  C. 5
  D. 7
  B. 4

• Question 114:

  Which of the following is the simplest way to define a recordwith fields corresponding to all of the columns that are fetched from a cursor or cursor variable?

  A. Using the VARRAY attribute
  B. Using the READ FROM CURSOR attribute
  C. Using the %ROWTYPE attribute
  D. Using the %CURSOR attribute
  C. Using the %ROWTYPE attribute

• Question 115:

  What is correct use of the MODULE?

  A. Encryption and encapsulation
  B. Grouping object definitions together that has a common business purpose
  C. Improving performance of transactions
  D. Supporting referential integrity
  B. Grouping object definitions together that has a common business purpose