ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

DB2 Administration (OS390) Test

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.



Scope of the online DB2 Administration (OS390) Test

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

Duration

40 minutes.

Assessment Method of Questions

Multiple choice questions

Each question has between 2 and 8 options out of which 1 or more may be correct.

More links

Related Professions

Database Administrator, Mainframe Programmer, programmer, developer

Keywords

db2 administration (OS390) assessment test, information technology, computers, IT industry