This certification exam certifies that the successful candidate has important knowledge, skills, and abilities necessary to design, build, execute, and deploy DB2 9.7 database applications.
Significant experience with intermediate or advanced level skills in developing applications that interact with DB2 databases. This individual has strong skills in DB2 SQL and in database application development concepts.
Section 1 - Database Objects (11%)
a.Demonstrate knowledge of naming conventions of DB2
b.Describe when to use SQL routines, functions and modules
c.Demonstrate knowledge of data types
Section 2 - Traditional Data Manipulation (32%)
a.Demonstrate knowledge of authorities needed to access data
in an application
b.Describe the differences between dynamic and static SQL
c.Demonstrate knowledge of how to query databases across
multiple tables and views
d.Given a scenario, demonstrate knowledge of changing data
e.Demonstrate knowledge of cursors
f.Given a scenario, demonstrate the ability to manipulate large
g.Demonstrate the ability to manage a unit of work
Section 3 - XML Data Manipulation (15%)
a.Given a scenario, demonstrate knowledge of XML schema
b.Demonstrate the ability to use XML functions
c.Given a scenario, demonstrate knowledge of how to use
XQuery expressions and evaluate the results
d.Given a scenario, describe how to construct queries that
retrieve both traditional and XML data
Section 4 - Core Concepts (27%)
a.Describe how to bind and rebind a package
b.Given a scenario, demonstrate knowledge of using parameter
markers
c.Demonstrate knowledge of how to connect to a database (mayuse scenarios)
d.Demonstrate the ability to submit an SQL statement
e.Describe how to manipulate result sets
f.Demonstrate knowledge of problem determination
Section 5 - Advanced Programming (15%)
a.Given a scenario, describe how to create and register external
b.Given a scenario, describe how to create external functions
c.Given a scenario, demonstrate knowledge of how changing
d.Demonstrate knowledge of distributed unit of work (two phasecommit)
e.Demonstrate knowledge of trusted contexts
f.Demonstrate knowledge of using advanced database objects
