DB2 9.7 SQL Procedure Developer (000-545) Free Practice Test

Question 1

Given the following DDL:

what will the SALARY be?

A. salary * 1.03

B. salary * 1.05

C. salary * 1.50

D. salary * 1.10

Correct Answer: C

Question 2

Given the following procedures:

What would be value of the variable TOTAL_SCORE if the PROCESS_SCORES procedure is called with the value 23 provided as input?

A. 2323

B. 1010

C. 0

D. 66

Correct Answer: D

Question 3

Which statement is TRUE about associative arrays?

A. Associative array cannot be a type of a table column.

B. The index data type for an associated array must be an integer.

C. Associative array values can be stored in table columns.

D. The index values for an associative array must be a continuous set of integer values.

Correct Answer: A

Question 4

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 TO CLIENT clause in order to return a result set.

D. The cursor declaration requires the WITH RETURN clause in order to return a result set.

Correct Answer: B

Question 5

Given the procedure shown below:

How many rows will be inserted in the table?

A. 3

B. 0

C. 1

D. 2

Correct Answer: B

Question 6

Given the variable declaration shown below: DECLARE v_mydate DATE; Which statement will assign a value to the variable V_MYDATE?

A. VALUES CURRENT TIMESTAMP INTO v_mydate;

B. VALUES (08262010) INTO v_mydate;

C. SELECT CURRENT DATE INTO v_mydate FROM SYSIBM.SYSDUMMY1;

D. SELECT CURRENT TIMESTAMP INTO v_mydate FROM SYSIBM.SYSDUMMY1;

Correct Answer: C

Welcome to TestSimulate