Want to pass your DB2 9.7 SQL Procedure Developer C2090-545 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
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. CONTAINS SQL
B. READS SQL DATA
C. MODIFIES SQL DATA
D. LANGUAGE SQL
Which of the following statements is true?
A. A DATETIME value can be assigned to a DATE variable.
B. Values cannot beassigned to variables inside ERROR HANDLERS.
C. A TIMESTAMP value can be assigned to a TIME variable.
D. The result of a GET DIAGNOSTICS statement cannot be assigned to a variable.
Given the SQL statement shown below:

Which privilege allows a user to execute the CREATE TRIGGER statement shown?
A. SYSCTRL authority
B. SELECT and UPDATE privilege on the EMPLOYEE table
C. SYSMAINTauthority
D. SELECT and ALTER privilege on the EMPLOYEE table