Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

DB2 Administration z/OS

Description:

Our DB2 Administration (z/OS) test measures your knowledge of administering DB2 databases. It includes content from the version 8 release. We also offer a DB2 Administration (UDB) operating system test designed for administrators. DB2 (z/OS) is designed for experienced administrators and covers the following topics: Application Program Features, Data Sharing, Database Design Environment Locking and Concurrency, Monitoring and Tuning, Operation and Recovery, SQL, Stored Procedures, Triggers and User Functions, Utilities and Commands.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Application Program Features
Commit, Rollback and Savepoint
Global Temporary Tables
Identity Columns
Materialized Query Tables
Sequence Objects
Data Sharing
Data Sharing Components
Enabling Data Sharing
Operating Data Sharing
Database Design
Data Access and Security
Data Definition
Data Manipulation
Data Retrieval
Database Objects
Referential and Check Constraints
Environment
Address Spaces
Catalog and Directory
Database Limits
Installation and Migration
Interfaces
Products
System Parameters
Locking and Concurrency
Claims and Drains
Data Locking Issues
Tuning Data Locks
Monitoring and Tuning
Access Paths and Optimization
Application Performance Tuning
Database Monitoring
Explain Reports
Memory Tuning
Traces
Operation and Recovery
Data Recovery
Image Copies
Logging
System Recovery
SQL
Case Expressions
Dynamic SQL
Joins
Table Expressions
Unions
Stored Procedures, Triggers and User Defined Functions
Stored Procedures
Triggers
User Defined Functions
Utilities and Commands
CATMAINT Utility
CHECK Utility
Commands
LOAD Utility
QUIESCE Utility
REORG Utility
RUNSTATS Utility