E case statements are used to iterate intosome logic

E. CASE statements are used to iterate intosome logic based on a literal value.
Answer: A, B
QUESTION: 111
Which code fragment illustrates the proper way to capture and save SQL error
handler values so they can be used to control procedure logic?
A. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING,
NOT FOUND
SET retcode = SQLCODE;

B. DECLARE ERROR HANDLER FOR SQLEXCEPTION, SQLWARNING,
NOT FOUND SET retcode = EXCEPTION;
C. DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT
FOUND SET retcode = SQLERRN;
D. DECLARE ERROR HANDLING FOR SQLEXCEPTION, SQLWARNING,
NOT FOUND SET retcode = SQLMSG;
Answer: A
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'
Answer: D
QUESTION: 113
Which of the following CURSOR declare statement is incorrect?
A. DECLARE c1 CURSOR WITHOUT RETURN FOR SELECT * FROM tab1
B. DECLARE c1 ASENSITIVE CURSOR WITH RETURN TO CLIENT FOR
SELECT * FROM tab1
C. DECLARE c1 INSENSITIVE CURSOR WITH RETURN TO CLIENT FOR
SELECT * FROM tab1
D. DECLARE c1 SENSITIVE CURSOR WITH RETURN TO CLIENT FOR
SELECT * FROM tab1
Answer: D
QUESTION: 114
Which rule applies to the REFERENCING clause in a CREATE TRIGGER
statement?
A. The OLD correlation-name and the OLD TABLE identifier can be used if the
trigger event is an INSERT operation.

B. The scope of each correlation-name and identifierused is the entire trigger
definition.
C. The OLD TABLE or NEW TABLE identifiers can be defined in a BEFORE
trigger.
D. A NEW correlation-name can be specified more than once for a trigger.
Answer: B
QUESTION: 115
Which of the following statement isTRUE about a REPEAT loop?
A. The condition is checked at the end of the loop.
B. The condition is checked at the beginning of the loop.
C. A REPEAT loop behaves like a WHILE loop.
D. A REPEAT loop behaves like a FOR loop.
Answer: A

For More exams visit http s ://killexams.com /vendors-exam-list
Kill your exam at First Attempt .... Guaranteed!