Flylib.com
DB2 Universal Database V8.1 Certification Exam 700 Study Guide
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)
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
Similar book on Amazon
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
The CISSP and CAP Prep Guide: Platinum Edition
Java I/O
File Streams
Working with Files
Character Sets and Unicode
Parsing Input
The Java Communications API
ERP and Data Warehousing in Organizations: Issues and Challenges
Challenging the Unpredictable: Changeable Order Management Systems
ERP System Acquisition: A Process Model and Results From an Austrian Survey
Healthcare Information: From Administrative to Practice Databases
Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
Development of Interactive Web Sites to Enhance Police/Community Relations
Developing Tablet PC Applications (Charles River Media Programming)
Strings, GDI+, and Error Handling in VB .NET
Obtaining the Tablet PC SDK
Tablet PC Full Screen Utility
Virtual Joystick
Not Quite a Magic Ball
C++ How to Program (5th Edition)
Default Memberwise Assignment
Recommended Reading
H.2. Additional Diagram Types
I.1. Resources
J.9. Nested and Ordered Lists
Programming .Net Windows Applications
Performance
Text and Fonts
Fonts
Creating Your First Menu
Managed Providers
DNS & BIND Cookbook
Configuring a Name Server to Forward Dynamic Updates
Returning a Default Record
Configuring DNS to Let Clients Find the Closest Server
Dynamically Updating a Zone
Creating a Zone Programmatically
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies