DB2 Universal Database V8.1 Certification Exam 700 Study Guide
DB2 Universal Database V8.1 Certification Exam 700 Study Guide
ISBN: 0131424653
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 68
Pages: 68
Authors: Roger E. Sanders
- 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)
DB2 Universal Database V8.1 Certification Exam 700 Study Guide
ISBN: 0131424653
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 68
Pages: 68
Authors: Roger E. Sanders