IBM Certified Database Associate

DB2 UDB v8.1 Family Fundamentals

Role Description

The IBM Certified Database Associate certification role is an entry level DBA or a user of any of the DB2 family of products. This individual is knowledgeable about the fundamental concepts of DB2 Universal Database v8 through either hands on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how DB2 Universal Database v8.1 is packaged and installed, understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.

Certificate Requirements

Passing Exam 700—IBM DB2 UDB v8.1 Family Fundamentals earns you an IBM Certified Database Associate certification and provides you with the prerequisite for all intermediate DB2 certifications.

Earning this certification proves that you are able to use data in any of the DB2 Family of Servers: DB2 on Linux, UNIX, Windows, iSeries, or zSeries.

Exam Objectives

Exam 700, DB2 UDB v8.1 Family Fundamentals

This exam requires knowledge of the DB2 components that are required for your system, an understanding of the tools that are available with the products, and the ability to understand the authorities and privileges required to access data. Further, you must have knowledge of the basic SQL, DML, and DDL to work with DB2 data, as well as knowledge of data types and referential constraints to work with the basic DB2 objects (tables, views, etc). Finally, you must understand basic isolation levels, locking methods, and database concurrency.

Exam 700 contains a total of 54 questions. Candidates are required to score 61% or better to pass the exam.

Planning—15%

• Knowledge of DB2 UDB products (client, server, etc.)

• Knowledge of DB2 tools

• Knowledge of Datawarehouse and OLAP concepts

• Knowledge of non-relational data concepts (extenders, etc)

Security—9%

• Knowledge of restricting data access

• Knowledge of different privileges

Accessing DB2 UDB Data—15%

• Ability to identify and locate DB2 UDB servers

• Ability to create and manipulate DB2 UDB objects

• Ability to create basic DB2 UDB objects

Working with DB2 UDB Data—31%

• Knowledge of transactions

• Given a DDL SQL statement, knowledge to identify results

• Given a DCL SQL statement, knowledge to identify results

• Given a DML SQL statement, knowledge to identify results

• Ability to use SQL to SELECT data from tables

• Ability to use SQL to SORT or GROUP data

• Ability to use SQL to UPDATE, DELETE, or INSERT data

• Ability to call a procedure

Working with DB2 UDB Objects—19%

• Ability to demonstrate usage of DB2 UDB data types

• Given a situation, ability to create table

• Knowledge to identify when referential constraints should be used

• Knowledge to identify methods of data validation

• Knowledge to identify characteristics of a table, view or index

Data Concurrency—11%

• Knowledge to identify factors that influence locking

• Ability to list objects on which locks can be obtained

• Knowledge to identify characteristics of DB2 UDB locks

• Given a situation, knowledge to identify the isolation levels that should be used