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.

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