Certification Test Objectives

Team-Fly    

 
DB2 Universal Database for OS/390 v7.1 Application Certification Guide
By Susan Lawson
Table of Contents
Appendix A.  IBM Certified Solutions ExpertDB2 UDB Family Application Development

Certification Test Objectives

The IBM certified solutions expert for DB2 UDB in application development requires an in-depth knowledge of the difference between programming types (ODBC, JDBC, OLEDB, Embedded SQL) and when to use the different programming types:

  • The difference between embedded dynamic and static SQL

  • Basic and intermediate SQL

  • Concepts and usage of binding and prepping, isolation levels, basic database objects, and data types (schema, naming conventions)

  • Transaction concepts (commit scope, states) and cursor concepts

Furthermore, the solutions expert in application development should have a basic knowledge of

  • Diagnostic information

  • Advanced SQL (recursive, DDL, temporary tables, and compound)

  • Locking

  • Privileges and authorities

  • SQL routines and functions

  • Complex database objects (UDTs, UDFs, triggers)

  • SQLDA

  • SQLCA

  • Host variables

  • Parameter markers

  • Connection types

  • Transaction manager

The following are some of the topics covered on the exam.

I. Database Objects

  • Knowledge of naming conventions of DB2 objects (aliases, views, etc.)

  • Knowledge of the authorities needed to access data in an application

  • Knowledge of complex database objects (temporary tables, summary tables, triggers)

II. Data Manipulation

  • Ability to query database across multiple tables

  • Ability to query tables across multiple databases (federated databases)

  • Knowledge of changing data

  • Ability to use DB2 SQL functions

  • Ability to use common table expressions

  • Knowledge to identify when to use cursors in a SQL program

  • Knowledge to identify types of cursors

  • Knowledge to identify the scopes of cursors

  • Ability to manipulate cursors

  • Ability to manage a unit of work (transaction management)

III. DB2 Programming Methods

  • Knowledge to identify the differences between dynamic and static embedded SQL

  • Skill in determining when to use CLI/ODBC

  • Skill in determining when to use JDBC and SQLJ

  • Ability to determine when to use SQL routines and functions

  • Ability to determine when to use OLEDB

IV. Embedded SQL Programming

  • Knowledge of identifying steps and output involved in creating an embedded SQL programming application

  • Knowledge to identify when host variables are used begin-declare)

  • Skill in declaring host variables

  • Skill in utilizing host variable in queries

  • Ability to explain and analyze the content of the SQLCA

  • Knowledge of common errors, prep, and BIND database programs

  • Ability to connect to databases within an embedded SQL programming application

V. ODBC/CLI Programming

  • Knowledge of the different handle types

  • Knowledge of configuring DB2 ODBC driver

  • Knowledge of problem determination (diagnostic records)

  • Knowledge of the correct sequence for calling ODBC/CLI functions

  • Knowledge of various CLI cursor types and when to use them

  • Ability to connect to databases within an ODBC/CLI programming application

VI. JAVA Programming

  • Knowledge of various JDBC objects

  • Knowledge of the difference between SQLJ and JDBC

  • Knowledge of problem determination (JDBC trace, SQL exceptions, and JDBC error log)

  • Skill in performing the steps to build SQLJ applications

  • Ability to connect to databases within a JAVA programming application

  • Ability to manage transactions across multiple databases (JTA)

  • Ability to determine which connection types should be used to connect to the database

VII. Advanced Programming

  • Ability to utilize dynamic and static SQL within programs

  • Skill in casting UDTs within a program

  • 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

  • Ability to determine the approaches to programming using Unicode

  • Ability to use performance enhancement features (CLI Load, buffered inserts )

VIII. Stored Procedures and User-Defined Routines

  • Knowledge to identify usage of UDFs

  • Knowledge to identify when to use stored procedures

  • Skill in using the DB2 Development Center

  • Knowledge of programming languages using the DB2 Development Center


Team-Fly    
Top


DB2 Universal Database for OS. 390 v7. 1 Application Certification Guide
DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)
ISBN: 0131007718
EAN: 2147483647
Year: 2002
Pages: 163
Authors: Susan Lawson

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net