Exploring Exam 700: DB2 UDB V8.1 Family Fundamentals

This section provides information about the DB2 UDB V8.1 Family Fundamentals exam. It describes the role of a database associate and the exam requirements and objectives that you need to become familiar with as you prepare for exam 700.

The role of a certified database associate

The professional who earns the IBM Certified Database Associate certification 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 Version 8 through hands-on experience or through formal or informal education. A database associate should have the following level of knowledge:

  • In-depth knowledge of the basic-to-intermediate tasks that are required in day-to-day administration and basic SQL

  • Basic understanding of how the DB2 Universal Database Version 8 products are packaged and installed

  • Basic understanding of how to create databases and database objects

  • Basic knowledge of database security and transaction isolation

Certification requirements

When you pass exam 700, you earn the IBM Certified Database Associate certification. This certification qualifies as the prerequisite for all intermediate DB2 UDB certifications.

Becoming certified as a DB2 database associate proves that you can work with data in any of the DB2 family of database servers: DB2 UDB on z/OS, Linux, UNIX, Windows, or iSeries.

Exam 700 objectives

Exam 700 requires knowledge of the DB2 components that are required for your system, an understanding of the tools that are available with the DB2 UDB products, and the ability to understand the authorities and privileges that are required for data access. Further, you must have knowledge of the basic SQL, DML (data definition language), and DDL (data definition language) constructs that you need to work with DB2 data, and knowledge of data types and referential constraints to work with the basic DB2 objects (tables, views, and so on). Finally, you must understand basic isolation levels, locking methods, and database concurrency.

Exam 700 contains a total of 54 questions. Candidates are required to score 61% or higher to pass the exam. The exam questions are divided into the following six sections:

Planning – 15%

  • Knowledge of DB2 UDB products (client, server, etc.)

  • Knowledge of DB2 tools

  • Knowledge of data warehouse and OLAP concepts

  • Knowledge of nonrelational data concepts (extenders, and so on)

Planning topics are covered in the following chapters:

Security – 9%

  • Knowledge of restricting data access

  • Knowledge of different privileges

Security is covered in the following chapter:

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

Accessing DB2 UDB data is covered in the following chapters:

  • Chapter 5. Working with SQL: The language of DB2

  • Chapter 7. Implementing your database design

Working with DB2 UDB data – 31%

  • Knowledge of transactions

  • Given a DDL SQL statement, knowledge to identify results

  • Given a DCL SQL statement, knowledge to identify results

  • Given a DML 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

Working with DB2 UDB data is covered in the following chapters:

Working with DB2 UDB objects – 19%

  • Ability to demonstrate use of DB2 UDB data types

  • Given a situation, ability to create a table

  • Knowledge to identify when referential constraints should be used

  • Knowledge to identify methods of data validation

  • Knowledge to identify characteristics of a table, view, or index

Working with DB2 UDB objects is covered in the following chapters:

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 which isolation levels to use

Data concurrency is covered in the following chapter:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.145.204.201