DB2 UDB V8 Family Fundamentals: 700 Exam

The 700 examDB2 UDB V8 Family Fundamentalsis divided into six sections.

Section 1: Planning (15 Percent)

• Knowledge of DB2 UDB products: client, server, and so on

• Knowledge of the features in DB2 tools, such as DB2 Extenders, Configuration Assistant, Visual Explain, Command Center, Control Center, Relational Connect, Replication Center, Development Center, and Health Center

• Knowledge of data warehouse and OLAP concepts

• Knowledge of nonrelational data concepts, such as Extenders

Section 2: Security (9 Percent)

• Knowledge of restricting data access

• Knowledge of various privileges

Section 3: Accessing DB2 UDB Data (15 Percent)

• Ability to identify and locate DB2 UDB servers

• Ability to access and manipulate DB2 UDB objects

• Ability to create basic DB2 UDB objects

Section 4: Working with DB2 UDB Data (31 Percent)

• Knowledge of transactions

• Given a DDL SQL statement, knowledge to identify results

• Given a DML SQL statement, knowledge to identify results

• Given a DCL 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

Section 5: Working with DB2 UDB Objects (19 Percent)

• Ability to demonstrate use of DB2 UDB data types

• Given a situation, ability to create table

• Knowledge to identify when referential integrity should be used

• Knowledge to identify methods of data constraint

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

Section 6: Data Concurrency (11 Percent)

• 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