DB2 v.8 Mainframe DBA Assessment

$16.00

DB2 v.8 Mainframe DBA Assessment

$16.00
description

DB2 v.8 Mainframe DBA measures the overall knowledge of an OS/390 and z/OS DB2 DBA from either a systems or applications DBA perspective. Test questions will be derived from topics such as the Creation and Management of DB2 Objects, Data Recovery, Performance and Tuning, DB2 Utilities and Commands, and Security.

 

Number of questions 40
Competencies tested Create/Manage DB2 Objects
Data Recovery
Performance Monitoring and Tuning
Security
Utilities and Commands
Tasks tested Primary and Unique Keys
Unique Indexes
Check Constraints
Altering a Tablespace
Adding a Column to a Table
Creating a Segmented Tablespace
Index Definition
Tablespace Types
Adjusting the SEGSIZE
Views
Index Properties
Establishing a Point of Consistency
Access During Image Copy
Recovery Concepts
Disaster Recovery
Tablespace Recovery
Image Copies
LOGAPPLY
Logging
Index Design
Tablespace REORGs
EXPLAIN Tool
SQL Optimization and Tuning
DB2 PM Reports
DB2 Components
PLAN_TABLE
Granting DB2 Access
Authorization Levels
DCL Interpretation
DB2 Privileges
Resetting RBDP Status Condition
Using the LOAD Utility
RUNSTATS
Load Option Delete
Using DB2 Commands
Load Option Create
DB2 Commands
Executing Utilities