|
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%) - Knowledge of naming conventions of DB2 objects
- Knowledge of the authorities needed to access data in an
application
- Knowledge of complex database objects
- Knowledge to
identify the differences between dynamic and static SQL
- Ability to
determine when to use programming interfaces available
- Ability to
determine when to use SQL routines and functions
Section 2 - Data Manipulation (26%) - Ability to
query databases across multiple tables and views
- Ability to use common
table expressions
- Ability to work with MQT's
- Ability to use
DB2's built in routines
- Knowledge of changing data
- Knowledge to
identify when to use cursors
- Knowledge to identify types of
cursors
- Ability to manipulate cursors
- Ability to manipulate
large objects
- Ability to manage a unit of work
Section 3 - XML Data Manipulation (10%) - Knowledge to identify the results of XML parsing
- Ability to
identify the results of XML Serialization
- Knowledge of document
encoding management
- Knowledge of XML Schema Validation
- Ability
to execute an XQuery expression
- Ability to identify the results of an
XQuery/XPath expression
- Knowledge of SQL/XML functions
Section 4 - Embedded SQL Programming (4%) - Ability to connect to databases within an embedded SQL programming
application
- Skill in executing SQL statements
- Ability to
analyze results and common errors
Section 5 - ODBC/CLI Programming (4%) - Ability
to connect to databases within an ODBC/CLI programming
application
- Knowledge of the correct sequence for calling ODBC/CLI
functions to execute SQL request
- Ability to analyze results and
knowledge of problem determination
Section 6 - .NET Programming (7%) - Knowledge of
ADO.NET object model
- Ability to connect to the database with
ADO.NET
- Skill in exeucting SQL statements and working with the
results
- Ability to analyze results and knowledge of problem
determination
- Knowledge of IBM DB2 Add-Ins for Visual Studio
Section 7 - Java Programming (7%) - Knowledge of
JDBC/SQLJ object model
- Ability to connect to databases within a
JDBC/SQLJ application
- Skill in executing SQL statements
- Ability
to analyze results and knowledge of problem determination
- Knowledge of
DB2 Add-Ins for Eclipse
Section 8 - Advanced Programming (14%) - Ability
to query tables across multiple databases
- Ability to create triggers
and identify their results
- Understand how changing data will work when
referential constraints are involved
- Knowledge to identify when to use
Compound SQL
- Knowledge of concurrency considerations within an
application
- Knowledge of distributed unit of work
- Knowledge of
using parameter markers
Section 9 - User Defined Routines (12%) - Knowledge to identify usage of User Defined Functions
- Ability
to create a User Defined Functions
- Knowledge to identify when to use
stored procedures
- Ability to create SQL stored
procedures
- Ability to create an external stored
procedures
- Skill in using the DB2 Developer Workbench
| 
