DB2 UDB V7 - Section 1 - Installation & Planning (11%)...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Ability to Install DB2 Universal Database, DB2 Clients & Developers Edition Knowledge of and ability to use the DB2 UDB GUI Tools and CLP Knowledge of concepts of Data warehouse and OLAP Issues Knowledge of new V7.1 tools Section 2 - Security and Instances (9%) Ability to describe the functionality of the Administration Server Instance (DAS) Ability to provide users with authority on DB objects Section 3 - Creating and Accessing DB2 Databases (13%) Ability to create a DB2 database Ability to catalog a remote database or local database or DRDA Ability to use the DB2 GUI tools to create, access and manipulate DB2 objects Ability to create and access basic DB2 objects Section 4 - SQL Usage (38%) Ability to start/end a unit of work Given a DDL SQL statement, knowledge to identify results Given a DML SQL statement, knowledge to identify results Given a DCL SQL statement, knowledge to identify results
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

DB2 UDB V7 - Section 1 - Installation & Planning (11%)...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online