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 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
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 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:
Chapter 9. Managing DB2 operations
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:
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:
Chapter 2. DB2 concepts
Chapter 5. Working with SQL: The language of DB2
Chapter 6. Writing an application program
Chapter 9. Managing DB2 operations
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:
Chapter 2. DB2 concepts
Chapter 4. Designing objects and relationships
Chapter 5. Working with SQL: The language of DB2
Chapter 7. Implementing your database design
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:
Chapter 8. Managing DB2 performance
3.145.204.201