Test 512 Objectives

fengming

DB2 UDB V7.1 Family Fundamentals
Test 512 Objectives

IBM certifications in DB2 UDB V7.1 require an in-depth knowledge of basic SQL, DML, DDL, and an understanding of database objects (tables, views, etc.). Further, a basic understanding of the concepts and features of DCL, database creation, data types, stored procedures, programming, components and packaging (SDK, EEE, etc.), protocols supported, installation of products, GUI tools, CLP, basic isolation levels, and import/export is required.

Listed below are the primary objectives which the DB2 UDB V7.1 Family Fundamentals test covers. These objectives are listed here to assist you in your preparation for this test which is a required component towards any DB2 UDB V7.1 certification role.

There are a total of 55 questions. To pass this exam you must score 55% or greater. You will have 75 minutes to take this test.


Section 1 - Installation & Planning

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 Datawarehouse and OLAP Issues
Knowledge of new V7.1 tools
Section 2 - Security and Instances

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

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

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
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
Knowledge to identify the affect of a COMMIT or ROLLBACK statement
Knowledge to identify the scope of a COMMIT or ROLLBACK
Section 5 - Database Objects

Ability to demonstrate usage of DB2 data types
Given a situation, ability to create a table
Given a situation, knowledge to identify when referential constraints are used
Knowledge to identify methods of data validation
Knowledge to identify characteristics of a table, view or index
Knowledge of concepts of extenders
Section 6 - Database Concurrency

Knowledge to identify factors that influence locking
Ability to list the objects that locks can be obtained on
Knowledge to identify scope of different types of DB2 locks
Knowledge to identify factors affecting amount of locks that are used
Knowledge to identify factors affecting the type of locks obtained
Given a situation, knowledge to identify the isolation levels that should be used