DB2 9 Fundamentals: Certification Study Guide

Chapter 3: Security

Table 3-1: Requirements for Granting/Revoking Authorities and Privileges

Table 3-2: Common Job Titles, Tasks, and Authorities/Privileges Needed

Chapter 4: Working with Databases and Database Objects

Table 4-1: DB2 9 Instance Management Commands

Table 4-2: Built-In Data Type Definitions That Can Be Used with the CREATE TABLE Statement

Chapter 6: Working with DB2 Tables, Views, and Indexes

Table 6-1: DB2 9 Date and Time Formats

Table 6-2: DB2 Database Manager-Supplied Default Values

Table 6-3: Referential Integrity Constraint Terminology

Table 6-4: Data Type Definitions That Can Be Used with the CREATE TABLE Statement

Chapter 7: Database Concurrency

Table 7-1: DB2 9's Isolation Levels and the Phenomena That Can Occur When Each Is Used

Table 7-2: Lock States

Table 7-3: Types of Transactions Available and Their Associated Locks

Table 7-4: Lock Compatibility Matrix