---

DB2 Universal Database V8.1 Certification Exam 700 Study Guide

ISBN: 0131424653
EAN: 2147483647

Year: 2003
Pages: 68

Authors: Roger E. Sanders

BUY ON AMAZON

• Main Page
• Table of content
• Copyright
• IBM Press SeriesInformation Management
• About Prentice Hall Professional Technical Reference
• Foreword
• Preface
• About This Book
• Conventions Used
• Acknowledgments
• About the Author
• Part 1: DB2 UDB Certification
• Chapter 1. IBM DB2 Universal Database Certification
• DB2 Universal Database Certification Roles
• The Certification Process
• Part 2: DB2 UDB Family Fundamentals
• Chapter 2. Planning
• The DB2 Universal Database Family
• DB2 Universal Database s Comprehensive Tool Set
• Practice Questions
• Answers
• Chapter 3. Security
• Controlling Database Access
• Authentication
• Authorities and Privileges
• Granting Authorities and Privileges
• Authorities and Privileges Needed to Perform Common Tasks
• Practice Questions
• Answers
• Chapter 4. Accessing DB2 UDB Data
• Servers, Instances, and Databases
• What Makes Up a DB2 UDB Database?
• Creating a DB2 UDB Database with the CREATE DATABASE Command
• Creating a DB2 UDB Database with the Create Database Wizard
• Deleting a DB2 UDB Database
• DB2 UDB s Directory Files
• Cataloging and Uncataloging a DB2 UDB Database
• Cataloging and Uncataloging a Node
• Cataloging and Uncataloging a DCS Database
• Cataloging Remote Databases with the Add Database Wizard
• Database Objects
• Practice Questions
• Answers
• Chapter 5. Working with DB2 UDB Data
• Structured Query Language (SQL)
• The SELECT Statement and Its Clauses
• Answers
• Chapter 6. Working with DB2 UDB Objects
• DB2 Universal Database s Data Types
• Understanding Constraints
• Creating Tables with the CREATE TABLE SQL Statement
• CREATE TABLE SQL Statement Examples
• Practice Questions
• Answers
• Chapter 7. Database Concurrency
• Understanding Data Consistency
• Isolation Levels
• Locking
• Practice Questions
• Answers
• Appendix A. DB2 UDB V8.1 Family Fundamentals Exam (Exam 700) Objectives
• Planning (15)
• Security (9)
• Accessing DB2 UDB Data (15)
• Working with DB2 UDB Data (31)
• Working with DB2 UDB Objects (19)
• Data Concurrency (11)