DB2 9 Fundamentals: Certification Study Guide

Overview

Seventeen percent (17%) of the DB2 9 Fundamentals certification exam (Exam 730) is designed to test your knowledge of the different objects that are available with DB2 9 and to test your ability to create a DB2 9 database. The questions that make up this portion of the exam are intended to evaluate the following:

• Your ability to identify and connect to DB2 servers and databases

• Your ability to construct a DB2 9 database

• Your ability to identify DB2 objects

• Your knowledge of the basic characteristics and properties of DB2 objects

• Your ability to identify the Data Definition Language (DDL) statements available with DB2 9

• Your ability to identify the results produced when a DDL statement is executed

This chapter is designed to introduce you to instances and databases, to walk you through the database creation process, and to provide you with an overview of the various objects that can be developed once a database has been created.