IBM DB2 9.7 SQL Procedure Developer 認定 000-545 試験問題:

1. Which two statements are true when working with triggers? (Choose two.)

A) Triggers can be used to enforce data integrity rules.
B) Triggers can be used with both tables and views.
C) Triggers can be used on Materialized Query Tables.
D) Triggers can be used on Created Temporary Tables.
E) Triggers can be altered.

2. When considering authorization for CREATE OR REPLACE PROCEDURE statements, the authorization id must have:

A) IMPLICIT_SCHEMA authority on the database
B) ownership of the existing procedure
C) DBADM authority
D) group privileges on the table or view specified in the procedure

3. A developer wants to code the following statements in an SQL procedure:

What order must these statements be coded in?

A) 4, 3, 2, 1
B) 2, 4, 3, 1
C) 1, 2, 3, 4
D) 3, 4, 2, 1

4. Which two statements describe a CASE statement? (Choose two.)

A) CASE statements are used to enter into some condition and loop until the condition is met.
B) CASE statements are used to enter into some logic based on a literal value.
C) CASE statements are used to return control to the beginning of an expression.
D) CASE statements are used to enter into some logic based on the value of an expression.
E) CASE statements are used to iterate into some logic based on a literal value.

5. 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 ERROR HANDLING FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;
B) DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLCODE;
C) DECLARE ERROR HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = EXCEPTION;
D) DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLERRN;

質問と回答：