ClickATest Assessment Services

Only £52.00


Sample reports

Sample certificates

Adobe Reader is required to view these sample reports

DB2 Administration z/OS Test

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.



Scope of the Online DB2 Administration z/OS Test

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

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

Keywords

DB2 Administration z/OS assessment test, clickatest DB2 Administration z/OS assessment test, DB2 Administration z/OS test, information technology, computers, IT industry