IBM DB2 9.7 SQL Procedure Developer - 000-545 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Click the Exhibit button.

Which statement is true about the CASE statement shown in the exhibit?

A. An employee with a rating of 1 receives a 10% salary increase. B. An employee with a rating of 2 receives a 3% salary increase. C. An employee with a rating of 3 receives no salary increase. D. All employees will receive at least a 5% salary increase.

Discussion 0

Correct Answer: A Vote an answer

Question 2

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

Discussion 0

Correct Answer: D Vote an answer

Question 3

Given the following CREATE PROCEDURE statement: In what order must declarations occur within the lines ap: BEGIN and END ap?

A. Condition handlers, cursors, variables B. Cursors, variables, condition handlers C. Condition handlers, variables, cursors D. Variables, cursors, and condition handlers

Discussion 0

Correct Answer: D Vote an answer

Question 4

Click the Exhibit button.

A trigger was created as shown in the exhibit.
The UPDATE statement shown below is executed. UPDATE dept SET sales_id = '300' WHERE sales_id = '200'
How many row(s) are updated in the EMPLOYEE table?

A. 3 B. 2 C. 1 D. 0

Discussion 0

Correct Answer: C Vote an answer

Question 5

Given the following DDL:

what will the SALARY be?

A. salary * 1.50 B. salary * 1.05 C. salary * 1.03 D. salary * 1.10

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which code fragment illustrates the proper way to perform error checking in SQL stored procedures?

A. ... BEGIN IF SQLCODE < 0 THEN RETURN -6786 END; B. ...
BEGIN
EXCEPTION < 0
ELSE;
NULL;
END;
... C. ...
IF SQLCODE < 0 THEN
RETURN -6786;
END IF;
... D. ...
IF
EXCEPTION < 0
ELSE THEN;
NULL;
ENDIF;
...

Discussion 0

Correct Answer: C Vote an answer