×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

DB2 10.1 Fundamentals: Certification Study Guide
     

DB2 10.1 Fundamentals: Certification Study Guide

3.0 1
by Roger E. Sanders
 

See All Formats & Editions

Beginning with an explanation of the certification process and working through fundamental exam objectives, this guide gives test-takers all they need to know to pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610). All the subjects covered on the exam are included: planning, security, data concurrency, working with databases and database objects,

Overview

Beginning with an explanation of the certification process and working through fundamental exam objectives, this guide gives test-takers all they need to know to pass IBM's DB2 10.1 Fundamentals certification exam (Exam 610). All the subjects covered on the exam are included: planning, security, data concurrency, working with databases and database objects, working with data using SQL and XQuery, working with DB2 tables, views, and indexes—and more. The book concludes with an extensive set of 150 practice questions that mirror the questions found on the exam and detailed answers that explain why the chosen answer is correct and why the others are wrong. Written by a DB2 authority who has helped IBM develop 21 DB2 certification exams, this is the ultimate resource for those who plan to earn their IBM Certified Database Associate certification.

Product Details

ISBN-13:
9781583473498
Publisher:
Mc Press
Publication date:
08/15/2014
Pages:
536
Sales rank:
276,655
Product dimensions:
7.00(w) x 8.90(h) x 1.20(d)

Read an Excerpt

DB2 10.1 Fundamentals

Certification Study Guide


By Roger E. Sanders

MC Press

Copyright © 2014 Roger E. Sanders
All rights reserved.
ISBN: 978-1-58347-743-4



CHAPTER 1

IBM DB2 Certification


Certification has long been a popular trend in the Information Technology (IT) industry. Consequently, many hardware and software vendors — including IBM — have certification programs in place that are designed to evaluate and validate an individual's proficiency with their product offerings.

Recognized throughout the world, the IBM Professional Certification Program offers a wide variety of certification options for IT professionals who want to demonstrate their knowledge and expertise with a particular IBM product. And if you regularly use IBM hardware, software, or both, chances are you have heard of this program and have thought about becoming IBM certified. But, are you aware that IBM has more than 275 different certification roles to choose from? More important, do you know which certification role is right for you? (And, do you know how to prepare for and take the certification exams that are required for the certification role you wish to pursue?)

This chapter is designed to provide you with answers to these and other questions. It begins by introducing you to the certification roles that have been defined for individuals who use IBM's DB2 Information Management software. Then, it shows you how to prepare for the DB2 certification exams, and it concludes with a discussion on how to navigate the testing software that IBM uses to administer most of its exams.


DB2 10 and 10.1 Certification Roles

The IBM Professional Certification Program consists of several distinct certification roles that are designed to guide you in your professional development. To obtain a particular certification, you simply select the role you wish to pursue (based on your knowledge and experience working with a particular IBM product), familiarize yourself with the requirements that have been defined for that role, and then take the required certification exam(s) for the role you have chosen. This book focuses on the IBM Certified Database Associate — DB2 10.1 Fundamentals role (as well as the exam you must take and pass to obtain this certification); however, two DB2 Version 10 and three DB2 Version 10.1 certification roles are currently available:

• IBM Certified Database Associate — DB2 10.1 Fundamentals

• IBM Certified Database Administrator — DB2 10.1 for Linux, UNIX, and Windows

• IBM Certified Database Administrator — DB2 10 for z/OS

• IBM Certified System Administrator — DB2 10 for z/OS

• IBM Certified Advanced Database Administrator — DB2 10.1 for Linux, UNIX, and Windows


IBM Certified Database Associate — DB2 10.1 Fundamentals

The IBM Certified Database Associate — DB2 10.1 Fundamentals certification is intended for entry-level DB2 users who are knowledgeable about the basic concepts of DB2 10.1 for Linux, UNIX, and Windows and DB2 10 for z/OS. In addition to having some hands-on experience or training (either formal or informal) on DB2 10 or DB2 10.1, individuals seeking this certification should:

[check] Know which DB2 10 and 10.1. products are available, as well as the function of each product (at a high level)

[check] Know which DB2 10 and 10.1 product to use for a given type of database workload (online transaction processing [OLTP], decision support system [DSS], or data warehouse)

[check] Know how to store and manipulate nonrelational data, such as large objects (LOBs) and Extensible Markup Language (XML) documents

[check] Possess an in-depth knowledge about the authorities and privileges that can be used to protect databases and data against unauthorized access and modification

[check] Know how to grant and revoke authorities and privileges

[check] Possess a basic understanding of Row and Column Access Control (RCAC)

[check] Possess a basic understanding of roles and trusted contexts

[check] Know how to create and connect to DB2 servers and databases

[check] Know how to create, access, and manipulate basic DB2 objects, such as tables, indexes, and views

[check] Know how and when to create system-period, application-period, and bitemporal temporal (time travel) tables

[check] Possess an in-depth knowledge of Structured Query Language (SQL), as well as an understanding of the Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL) statements that are available with DB2

[check] Know how to sort and group data

[check] Possess a strong understanding of transactions and know what constitutes a transaction boundary

[check] Know how to create and invoke SQL procedures and SQL user- defined functions (UDFs), as well as how to pass parameters to and retrieve results from SQL procedures and SQL UDFs

[check] Possess a basic knowledge of XQuery

[check] Know how to query temporal (time travel) tables

[check] Know how to use the various data types — including the Oracle® compatibility data types — that are available with DB2

[check] Know how and when to create temporary tables

[check] Know how and when to use the different types of constraints (NOT NULL, default, CHECK, UNIQUE, referential integrity, and informational) that are available with DB2

[check] Know how and when to create triggers

[check] Know how to use schemas

[check] Possess a basic understanding of the mechanisms (transactions, isolation levels, and locks) that are used to isolate the effects of transactions from one another in a multiuser environment

[check] Know which factors influence locking

[check] Know how and when to use the LOCK TABLE statement

[check] Be able to identify the characteristics of common DB2 locks that are used on both the Linux, UNIX, and Windows platform and the z/OS platform

[check] Be able to identify the appropriate isolation level to use for a given situation

[check] Know how and when to use Currently Committed semantics with the Cursor Stability isolation level


To obtain IBM Certified Database Associate — DB2 10.1 Fundamentals certification, candidates must take and pass the DB2 10.1 Fundamentals exam (Exam 610). Figure 1.1 illustrates the road map for acquiring this certification.

IBM Certified Database Administrator — DB2 10.1 for Linux, UNIX, and Windows

The IBM Certified Database Administrator — DB2 10.1 for Linux, UNIX, and Windows certification is designed for experienced B2 users who possess the knowledge and intermediate-to-advanced skills needed to perform the day-to-day administration of DB2 10.1 for Linux, UNIX, and Windows instances and databases. Along with being knowledgeable about DB2 fundamentals and having significant hands-on experience as a DB2 10.1 Database Administrator (DBA), individuals seeking this certification should:

[check] Know how to configure and manage DB2 servers, instances, and databases

[check] Know how to use the autonomic features that are available with DB2 10.1 for Linux, UNIX, and Windows

[check] Know how to perform administrative tasks using Data Studio

[check] Know how to create a new DB2 10.1 for Linux, UNIX, and Windows database

[check] Know how to create, access, modify, and manage DB2 database (data) objects

[check] Be able to convert an existing DB2 for Linux, UNIX, and Windows database to an automatic storage database

[check] Know how to use the ADMIN_MOVE_TABLE() procedure

[check] Possess a basic knowledge of DB2's partitioning capabilities

[check] Know how to store and manage XML data

[check] Be able to describe how classic and adaptive row compression works, as well as know how to enable a table or index for either type of compression

[check] Possess a basic knowledge of the new table features that were introduced in DB2 10.1

[check] Know how and when to use the multi-temperature data feature

[check] Know how and when to create NOT NULL, default, CHECK, UNIQUE, referential integrity, and informational constraints

[check] Know how and when to use the WITH CHECK OPTION clause of the CREATE VIEW statement

[check] Know how and when to create and use triggers

[check] Know how and when to use the SET INTEGRITY command

[check] Know how to use administrative views and SQL functions to monitor a DB2 10.1 database environment

[check] Possess a basic knowledge of the monitoring features available with Workload Manager

[check] Be able to use the auto-monitoring tools that are available with DB2 10.1

[check] Know how to use the DB2 Problem Determination Tool (db2pd)

[check] Know how to capture and analyze Explain information

[check] Know how to use the DB2 data movement utilities (EXPORT, IMPORT, LOAD, and db2move)

[check] Know how and when to use the Ingest utility

[check] Know how and when to use the REORGCHK, REORG, REBIND, RUNSTATS, and FLUSH PACKAGE CACHE commands

[check] Know how and when to use the DB2 Design Advisor

[check] Possess an in-depth knowledge of crash recovery, version recovery, and roll forward recovery

[check] Know how to perform database-level and table space-level backup and recovery operations

[check] Be able to configure and manage a High Availability Disaster Recovery (HADR) environment, as well as enable a standby server for read-only operations

[check] Possess a basic knowledge of the high availability (HA) features DB2 pureScale® provides

[check] Possess an in-depth knowledge of the authorities and privileges that can be used to protect databases and data against unauthorized access and modification

[check] Know which operations someone with Security Administrator (SECADM) authority can perform

[check] Possess a basic understanding of the Audit facility

[check] Possess a basic understanding of trusted contexts

[check] Possess an in-depth knowledge of RCAC

[check] Possess an in-depth knowledge of Label-Based Access Control (LBAC)

[check] Be able to configure database connectivity

[check] Know how to perform a DB2 Discovery request, as well as how to prevent DB2 Discovery requests from seeing servers, instances, and/or databases

[check] Know how to configure a DB2 server for Lightweight Directory Access Protocol (LDAP) connectivity


Candidates who have taken and passed either the DB2 9 Family Fundamentals exam (Exam 730) or the DB2 10.1 Fundamentals exam (Exam 610) can obtain IBM Certified Database Administrator — DB2 10.1 for Linux, UNIX, and Windows certification by taking (and passing) the DB2 10.1 DBA for Linux, UNIX, and Windows exam (Exam 611). All other candidates must take and pass both the DB2 10.1 Fundamentals exam (Exam 610) and the DB2 10.1 DBA for Linux, UNIX, and Windows exam (Exam 611). Figure 1.2 displays the road map for acquiring IBM Certified Database Administrator — DB2 10.1 for Linux, UNIX, and Windows certification.


IBM Certified Database Administrator — DB2 10 for z/OS

The IBM Certified Database Administrator — DB2 10 for z/OS certification is intended for experienced DB2 10 users who possess the knowledge and skills necessary to perform the intermediate-to-advanced tasks related to the design and implementation, installation and migration, backup and recovery, and daily operation and administration of DB2 10 databases residing on z/OS platforms. In addition to having significant experience as a DB2 for z/OS DBA and extensive knowledge of DB2 (including an understanding of new features and functionality available in Version 10), individuals seeking this certification should:

[check] Know how to normalize data, as well as how to translate a logical data model (entity-relationship model, process model, or both) into a physical database design

[check] Be able to design tables, indexes, and views

[check] Understand the different performance implications of identity columns, row IDs, sequence objects, reorder row formats, and hash access

[check] Know how to design table spaces (choose the proper page size, specify clustering, and so forth), as well as how to obtain a table space's attributes

[check] Possess a basic knowledge of DB2's partitioning capabilities

[check] Know how to implement user-defined rules of integrity

[check] Know how to create and modify DB2 data objects

[check] Know how to store and manage LOB and XML data

[check] Have an in-depth understanding of the impact that different encoding schemes can have on performance

[check] Understand data distribution and replication

[check] Know which operation and recovery commands to use in normal conditions

[check] Know which commands and utility control statements to use in abnormal conditions

[check] Be able to identify, as well as perform, the actions necessary to protect databases from planned and unplanned outages

[check] Be able to load data into and unload data from one or more tables

[check] Know how and when to reorganize DB2 objects

[check] Know how to monitor DB2 objects by collecting statistics

[check] Know how to monitor and manage threads and utilities

[check] Be able to identify and respond to advisory and restrictive statuses on objects

[check] Understand the significance of checkpoints

[check] Know how to identify and resolve database problems

[check] Know how to perform health checks

[check] Be able to develop backup and recovery procedures

[check] Be able to describe the special considerations for database recovery in a data sharing environment

[check] Understand the concept of disaster recovery

[check] Possess a basic understanding of virtual storage constraints and limitations

[check] Possess an in-depth knowledge of the authorities and privileges that can be used to protect databases and data against unauthorized access and modification

[check] Be able to audit DB2 activity and resources, as well as identify the primary audit techniques that are available

[check] Be able to identify and respond appropriately to trace output or error messages that indicate security problems

[check] Possess a basic understanding of roles and trusted contexts

[check] Possess an in-depth knowledge of RCAC

[check] Be able to plan for performance monitoring by setting up and running monitoring procedures

[check] Know how to analyze performance

[check] Know how to analyze and respond to RUNSTATS statistics analysis

[check] Know how and when to perform a REBIND operation

[check] Be able to calculate cache requirements for new applications

[check] Know how to implement data distribution and replication

[check] Possess a basic knowledge of how DB2 interacts with Workload Manager

[check] Be able to interpret traces, as well as explain the performance impact of using DB2 traces

[check] Be able to identify and respond correctly to critical performance metrics

[check] Know how to analyze and tune SQL statements

[check] Know the difference between static and dynamic SQL, as well as how each type of SQL performs

[check] Know how to design a database for performance

[check] Understand the critical DSNZPARMs

[check] Be able to identify the migration and upgrade modes available

[check] Be able to identify and describe the data sharing components available


Candidates can obtain IBM Certified Database Administrator — DB2 10 for z/OS certification by taking (and passing) either the DB2 9 Family Fundamentals exam (Exam 730) or the DB2 10.1 Fundamentals exam (Exam 610) and the DB2 10 DBA for z/OS exam (Exam 612). Figure 1.3 shows the road map for acquiring IBM Certified Database Administrator — DB2 10 for z/OS certification.


IBM Certified System Administrator — DB2 10 for z/OS

The IBM Certified System Administrator — DB2 10 for z/OS certification is designed for individuals who possess the knowledge and skills to describe the architecture and administer the processes needed to plan, install, manage, tune, and secure DB2 for z/OS environments. In addition to having significant hands-on experience with DB2 for z/OS, along with possessing extensive knowledge about the product (including an understanding of the new features and functionality available in Version 10), individuals seeking this certification should:

[check] Be able to develop an installation or migration plan for a given scenario

[check] Be able to identify additional environments (Workload Manager, UNIX System Services, XML schema support, Resource Access Control Facility [RACF®] or equivalent, and so forth) that a particular installation or migration might require

[check] Be able to describe how to execute an installation or migration plan for a given scenario


(Continues...)

Excerpted from DB2 10.1 Fundamentals by Roger E. Sanders. Copyright © 2014 Roger E. Sanders. Excerpted by permission of MC Press.
All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.
Excerpts are provided by Dial-A-Book Inc. solely for the personal use of visitors to this web site.

Meet the Author

Roger E. Sanders is the president of Roger Sanders Enterprises, Inc. and a senior consultant corporate systems engineer with EMC Corporation. He is the author of 22 books on relational database technology and has written articles for Certification magazine and IDUG Solutions journal. He lives in Fuquay-Varina, North Carolina.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

DB2 10.1 Fundamentals: Certification Study Guide 3 out of 5 based on 0 ratings. 1 reviews.
Anonymous More than 1 year ago
pass the exam today with 99% score, read this book thoroughly twice, there is absolutely NO way to fail ! there are typos but you could easily figure out ...