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 (OS390)

Description:

Our DB2 Administration (OS/390) test measures your knowledge of administering DB2 databases. We also offer a DB2 Administration (UDB) operating system test designed for administrators. DB2 (OS/390) is designed for experienced administrators, this test covers the following topics: Administration, Data Definition, Doors to DB2, Overview, Programming, SQL, Tools, Tuning, Utilities and Commands.

This test is associated with a Job Role. Please visit the Job Role Center for more details.

$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

Administration
Authorization Levels
Bufferpool
Commands
DB2 Installation
Database Configuration
Database Objects
Load
Logging
Partitioning Data
Recovery
Security
User Maintenance
Views
Data Definition
Constraints
Database Concepts
Foreign Key
Index
Naming rules
Stogroup
Stored Procedures
Synonym
Table
Tablespace
VCAT
Doors to DB2
CAF
CICS
IMS
TSO
Overview
Catalog Tables
Communication Protocol
DB2 Connect
DB2 Limits
DRDA
Platforms
Products
Programming
Application level locking
Bind
Collection
Cursor processing
DCLGEN
DDL
Data Types
Diagnostic Log
Dynamic SQL
General
Host Variables
Indicator Variables
ODBC/CLI
Package
Run Program
SQLCA
Unit of Work
SQL
DB2 Functions
Delete
General
Insert
Join
Select
Subqueries
Symbols
Temporary Table
Union
Update
Tuning
Access Paths
Bufferpool
Compression
Locking
OS/390 IFI Traces
Performance Monitor
RUNSTATS
Referential Integrity
Utilities and Commands
Copy
Load
Recover
Reorg
Unload