DB2 9 Fundamentals: Certification Study Guide

Overview

The DB2 9 Fundamentals exam (Exam 730) consists of 64 questions, and candidates have 90 minutes to complete the exam. A score of 59% or higher is required to pass this exam.

The primary objectives the DB2 9 Fundamentals exam (Exam 730) is designed to cover are as follows:

Planning (14%)

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

• Knowledge of the features and functions provided by DB2 tools such as the Control Center, the Configuration Advisor, the Configuration Assistant and the Command Line Processor

• Knowledge of database workloads (OLAP versus data warehousing)

• Knowledge of non-relational data concepts (extenders)

• Knowledge of XML data implications (non-shredding)

Security (11%)

• Knowledge of restricting data access

• Knowledge of different authorities and privileges available

• Knowledge of encryption options available (data and network)

• Given a DCL SQL statement, ability to identify results (GRANT, REVOKE, CONNECT statements)

Working with Databases and Database Objects (17%)

• Ability to identify and connect to DB2 servers and databases

• Ability to identify DB2 objects

• Knowledge of basic characteristics and properties of DB2 objects

• Given a DDL SQL statement, ability to identify results (ability to create DB2 objects)

Working with DB2 Data using SQL and XQuery (23.5%)

• Given a DML SQL statement, ability 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 INSERT, UPDATE, or DELETE data

• Knowledge of transactions (i.e., COMMIT, ROLLBACK, and transaction boundaries)

• Ability to call a procedure or invoke a user defined function

• Given an XQuery statement, knowledge to identify results

Working with DB2 Tables, Views, and Indexes (23.5%)

• Ability to demonstrate proper usage of DB2 data types

• Given a situation, ability to create a table

• Ability to identify when referential integrity should be used

• Ability to identify methods of data constraint

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

• Ability to identify when triggers should be used

• Knowledge of schemas

• Knowledge of data type options for storing XML data

Data Concurrency (11%)

• Ability to identify factors that influence locking

• Ability to list objects on which locks can be obtained

• Ability to identify characteristics of DB2 locks

• Given a situation, ability to identify the isolation level that should be used