IBM IBM Certified Solution Developer C2090-545 Questions & Answers

• Question 11:

  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

  Correct Answer: C

• Question 12:

  Click the Exhibit button.

  

  Referring to the exhibit, which two statements are correct? (Choose two.)

  A. If the EMPLOYEE_TEMP table exists, the execution order is 1,2,3.

  B. If the EMPLOYEE_TEMP table does not exist, the execution order is 1,4,3.

  C. If the EMPLOYEE_TEMP table exists, the execution order is 4,1,2,3.

  D. If the EMPLOYEE_TEMP table does not exist, the execution order is 4,1,3.

  E. If the messages table does not exist, the SQL procedure will still compile.

  Correct Answer: AB

• Question 13:

  Given the following statement: How many values are inserted in to the array called quantity?

  

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: D

• Question 14:

  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;

  Correct Answer: B

• Question 15:

  Which declaration is not valid?

  A. DECLARE var1 DECIMAL(9,2);

  B. DECLARE var1 VARCHAR(20);

  C. DECLARE var1 CHAR;

  D. DECLARE var1 INTEGER DEFAULT;

  Correct Answer: D

• Question 16:

  In a SQL Procedure, rows_fetched is an integer variable and curEmp is acursor variable of SELECT statement on a table. After opening the cursor curemp, which of the statement will determine the number of rows fetched?

  A. SET rows_fetched = curEmp%CURSOR_ROWCOUNT

  B. SET rows_fetched = curEmp%ROWCOUNT

  C. SET rows_fetched =CURSOR_ROWCOUNT(curemp)

  D. SET rows_fetched = ROWCOUNT(curemp)

  Correct Answer: C

• Question 17:

  Given the SQL statement shown below:

  

  Which statement correctly describesthe cursor MY_CURSOR?

  A. The cursor does not have sensitivity to insert, update, or delete operations that are made to rows in the underlying result table.

  B. The cursor will not be closed as a consequence of a commit operation.

  C. The result table of the cursor is intended to be used as a result set that will be returned from a procedure.

  D. The cursor can be used to perform positioned delete operations.

  Correct Answer: D

• Question 18:

  Given the procedure show below:

  

  What will be the value of P2?

  A. 50

  B. 51

  C. 100

  D. 102

  Correct Answer: C

• Question 19:

  Which option is used when declaring a global temporary table that will keep its data across transaction boundaries?

  A. ON ROLLBACK DELETE ROWS

  B. ON ROLLBACK PRESERVE ROWS

  C. ON COMMIT PRESERVE ROWS

  D. ON COMMIT DELETE ROWS

  Correct Answer: C

• Question 20:

  Which statement will create global variable?

  A. CREATE VARIABLE glob_emp_sal ANCHORE TO employee.salary

  B. PUBLISH VARIABLE glob_emp_sal DECIMAL(9,2)

  C. DECLARE GLOBAL VARIABLE glob_emp_sal DECIMAL(9,2)

  D. DECLARE GLOBAL VARIABLE glob_emp_sal ANCHORE TO employee.salary

  Correct Answer: A