Test 000-543: DB2 9.7 Application Development

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%)

1. Demonstrate knowledge of naming conventions of DB2objects
   1. Aliases
   2. Views
   3. Tables
2. Describe when to use SQL routines, functions and modules
   1. How to use DB2's built-in routines
      1. Functions
      2. Stored procedures
3. Demonstrate knowledge of data types
   1. Integer
   2. Floating point
   3. Strings
   4. Date/time
   5. LOBs
   6. XML data type

Section 2 - Traditional Data Manipulation (32%)

1. Demonstrate knowledge of authorities needed to access datain an application
2. Describe the differences between dynamic and static SQL
3. Demonstrate knowledge of how to query databases acrossmultiple tables and views
4. Given a scenario, demonstrate knowledge of changing data
   1. Insert
   2. Update
   3. Delete
5. Demonstrate knowledge of cursors
   1. Types of cursors
      1. Read only
      2. Updatable
      3. Scrollable
   2. Scope of cursors
   3. Create and manipulate cursors
6. Given a scenario, demonstrate the ability to manipulate largeobjects
   1. Locators
7. Demonstrate the ability to manage a unit of work
   1. Isolation levels
   2. COMMIT
   3. ROLLBACK
   4. SAVEPOINT

Section 3 - XML Data Manipulation (15%)

1. Given a scenario, demonstrate knowledge of XML schemavalidation
   1. XML schema evolution
2. Demonstrate the ability to use XML functions
   1. XMLPARSE
      1. Whitespace handling
   2. XMLSERIALIZE
   3. XMLTRANSFORM
   4. Functions for preparing XML documents fromrelational data
3. Given a scenario, demonstrate knowledge of how to useXQuery expressions and evaluate the results
4. Given a scenario, describe how to construct queries thatretrieve both traditional and XML data

Section 4 - Core Concepts (27%)

1. Describe how to bind and rebind a package
2. Given a scenario, demonstrate knowledge of using parametermarkers
3. Demonstrate knowledge of how to connect to a database (mayuse scenarios)
   1. JDBC
   2. ADO.NET
   3. CLI/ODBC
   4. php_ibm_db2
   5. Embedded SQL
4. Demonstrate the ability to submit an SQL statement
   1. JDBC
   2. ADO.NET
   3. CLI/ODBC
   4. php_ibm_db2
   5. Embedded SQL
5. Describe how to manipulate result sets
   1. JDBC
   2. ADO.NET
   3. CLI/ODBC
   4. php_ibm_db2
   5. Embedded SQL
6. Demonstrate knowledge of problem determination
   1. JDBC
   2. ADO.NET
   3. CLI/ODBC
   4. php_ibm_db2
   5. Embedded SQL

Section 5 - Advanced Programming (15%)

1. Given a scenario, describe how to create and register externalstored procedures
2. Given a scenario, describe how to create external functions
   1. OLE DB table
   2. External table
3. Given a scenario, demonstrate knowledge of how changingdata will work when referential constraints are involved
4. Demonstrate knowledge of distributed unit of work (two phasecommit)
5. Demonstrate knowledge of trusted contexts
6. Demonstrate knowledge of using advanced database objects
   1. Global declared temporary tables
   2. Sequences
   3. MQTs