DB2 UDB V7 - Section 1 Installation Planning(11 Ability to...

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 Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

DB2 UDB V7 - Section 1 Installation Planning(11 Ability to...

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