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
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Why Project Risk Management?
Identifying Project Scope Risk
Managing Project Constraints and Documenting Risks
Quantifying and Analyzing Activity Risks
Monitoring and Controlling Risky Projects
Building Web Applications with UML (2nd Edition)
Summary
Discussion
Summary
Mapping Web Elements to UML, and Vice Versa
User Experience Model
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Individual change
Leading change
Restructuring
Cultural change
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Understanding Intrusion Detection
Crash Course in the Internet Protocol Suite
Internet Security Systems RealSecure
Cisco Secure IDS
NFR Security
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
The Functional Triad Computers in Persuasive Roles
Computers as Persuasive Media Simulation
Credibility and the World Wide Web
Increasing Persuasion through Mobility and Connectivity
Captology Looking Forward
Junos Cookbook (Cookbooks (OReilly))
Configuring the Router by Copying a File from a Server
Configuring an IPv4 Address on an Interface
Choosing Primary and Preferred Interface Addresses
Filtering Traffic Using Unicast Reverse-Path Forwarding
Load-Balancing Traffic Flows
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