|
This Database Associate is an entry
level DBA or a user of any of the DB2 family of products. This individual is
knowledgeable about the fundamental concepts of DB2 Universal Database V8
through either hands on experience or formal and informal education. The
database associate should have an in-depth knowledge of the basic to
intermediate tasks required in day-to-day administration, basic SQL (Structured
Query Language), understand how DB2 Universal Database V8.1 is packaged and
installed, understand how to create databases and database objects, and have a
basic knowledge of database security and transaction
isolation. Section 1 - Planning (15%) - Knowledge of DB2 UDB
products (client, server, etc.)
- Knowledge of the features in DB2 tools
such as: DB2 Extenders, Configuration Assistant, Visual Explain, Command
Center, Control Center, Relational Connect, Replication Center, Development
Center, and Health Center
- Knowledge of Datawarehouse and OLAP concepts
- Knowledge of non-relational data concepts (extenders, etc)
Section 2 - Security (9%) - Knowledge of
restricting data access
- Knowledge of different privileges
Section 3 - Accessing DB2 UDB Data (15%) - Ability to identify and locate DB2 UDB servers
- Ability to
access and manipulate DB2 UDB objects
- Ability to create basic DB2 UDB
objects
Section 4 - Working with DB2 UDB Data (31%) - Knowledge of transactions
- 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
- Ability to use SQL to SELECT data from tables
- Ability to use
SQL to SORT or GROUP data
- Ability to use SQL to UPDATE, DELETE, or
INSERT data
- Ability to call a procedure
Section 5 - Working with DB2 UDB Objects (19%) - Ability to demonstrate usage of DB2 UDB data types
- Given a
situation, ability to create table
- Knowledge to identify when
referential integrity should be used
- Knowledge to identify methods of
data constraint
- Knowledge to identify characteristics of a table, view
or index
Section 6 - Data Concurrency (11%) - Knowledge
to identify factors that influence locking
- Ability to list objects on
which locks can be obtained
- Knowledge to identify characteristics of
DB2 UDB locks
- Given a situation, knowledge to identify the isolation
levels that should be used
|
