Test 735: DB2 9.5 SQL Procedure Developer

Section 1 - SQL Procedural Language (30%)

1. Describe how to use the DECLARE statement
2. Demonstrate the ability to code assignment statements
3. Demonstrate knowledge of SQL Control statements
4. Demonstrate knowledge of error handling

Section 2 - DB2 SQL Procedures (26%)

1. Demonstrate knowledge how to identify proper usage of SQL procedures
2. Demonstrate knowledge of the fundamental structure of an SQL procedure statement
3. Demonstrate knowledge of the proper structure of an SQL procedure body
4. Demonstrate knowledge of how to return values and result sets from SQL procedures
5. Demonstrate knowledge of nested procedures
6. Demonstrate how to test and deploy SQL procedure

Section 3 - Functions (16%)

1. Demonstrate knowledge how to identify proper usage of functions
2. Demonstrate the ability to use the CREATE FUNCTION statement
3. Demonstrate knowledge of the proper structure of a function body
4. Demonstrate knowledge of how to return values and a table using functions
5. Describe how to invoke functions
6. Demonstrate how to test and deploy functions

Section 4 - Triggers (10%)

1. Demonstrate knowledge how to identify proper usage of triggers
2. Demonstrate the ability to use the CREATE TRIGGER statement
3. Demonstrate the ability to identify the actions of a trigger
4. Demonstrate knowledge of advanced usage of triggers
5. Demonstrate how to test and deploy triggers

Section 5 - Advanced SQL Features (12%)

1. Demonstrate knowledge of Declared Global Temporary Tables
2. Describe how to use system features

Section 6 - Related Tools (6%)

1. Demonstrate knowledge of application development tools