Test 000-733: DB2 9 Application Developer

The test contains five sections totalling approximately 70 multiple-choice questions.  The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Database objects and Programming Methods (16%)

1. Knowledge of naming conventions of DB2 objects
2. Knowledge of the authorities needed to access data in an application
3. Knowledge of complex database objects
4. Knowledge to identify the differences between dynamic and static SQL
5. Ability to determine when to use programming interfaces available
6. Ability to determine when to use SQL routines and functions

Section 2 - Data Manipulation (26%)

1. Ability to query databases across multiple tables and views
2. Ability to use common table expressions
3. Ability to work with MQT's
4. Ability to use DB2's built in routines
5. Knowledge of changing data
6. Knowledge to identify when to use cursors
7. Knowledge to identify types of cursors
8. Ability to manipulate cursors
9. Ability to manipulate large objects
10. Ability to manage a unit of work

Section 3 - XML Data Manipulation (10%)

1. Knowledge to identify the results of XML parsing
2. Ability to identify the results of XML Serialization
3. Knowledge of document encoding management
4. Knowledge of XML Schema Validation
5. Ability to execute an XQuery expression
6. Ability to identify the results of an XQuery/XPath expression
7. Knowledge of SQL/XML functions

Section 4 - Embedded SQL Programming (4%)

1. Ability to connect to databases within an embedded SQL programming application
2. Skill in executing SQL statements
3. Ability to analyze results and common errors

Section 5 - ODBC/CLI Programming (4%)

1. Ability to connect to databases within an ODBC/CLI programming application
2. Knowledge of the correct sequence for calling ODBC/CLI functions to execute SQL request
3. Ability to analyze results and knowledge of problem determination

Section 6 - .NET Programming (7%)

1. Knowledge of ADO.NET object model
2. Ability to connect to the database with ADO.NET
3. Skill in exeucting SQL statements and working with the results
4. Ability to analyze results and knowledge of problem determination
5. Knowledge of IBM DB2 Add-Ins for Visual Studio

Section 7 - Java Programming (7%)

1. Knowledge of JDBC/SQLJ object model
2. Ability to connect to databases within a JDBC/SQLJ application
3. Skill in executing SQL statements
4. Ability to analyze results and knowledge of problem determination
5. Knowledge of DB2 Add-Ins for Eclipse

Section 8 - Advanced Programming (14%)

1. Ability to query tables across multiple databases
2. Ability to create triggers and identify their results
3. Understand how changing data will work when referential constraints are involved
4. Knowledge to identify when to use Compound SQL
5. Knowledge of concurrency considerations within an application
6. Knowledge of distributed unit of work
7. Knowledge of using parameter markers

Section 9 - User Defined Routines (12%)

1. Knowledge to identify usage of User Defined Functions
2. Ability to create a User Defined Functions
3. Knowledge to identify when to use stored procedures
4. Ability to create SQL stored procedures
5. Ability to create an external stored procedures
6. Skill in using the DB2 Developer Workbench