DB2 v.8 UDB DBA Assessment

  • $10.00

The IBM DB2 UDB V8 DBA assessment poses real world questions in order to assess the skill level of the assessment take. This assessment covers all areas and topics required by a database administrator to perform the day-to-day duties associated with their job. The skill set tested includes knowledge of DB2 products, tools, wizards, various DB2 utilities, product installations, upgrades and migrations, configuration of the database in recovery and non-recovery modes, performance tuning, security, and regular database maintenance activities.

The assessment is intended for those wishing to demonstrate their ability to perform DBA role and responsibilities in UNIX as well as Windows environments.

Assessments for DB2 V8 Mainframe DBA and DB2 5.x DBA are also available.

Number of questions 55
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered Backup and Recovery
Database Maintenance
DB2 Product Family
Installation and Configuration
Performance and SQL
Tasks tested Archive Logging
Blockpage Based Bufferpool I/O
Bufferpool Block and Page Base Size Ratio
Bufferpool Hit Ratio
Bufferpool Size for Partitions in a Partition DB
Bufferpool Start Issue
Bufferpools for Tablespaces
Bufferpools List
Configuration Parameter
Data Export File Type
Data Load
Data Migration
Data Validation with View Definition
DB Authority Display
DB Clone
DB Maintenance Authority
DB Restore Options
DB2 Add on Components
DB2 Authority Level
DB2 History File
DB2 Instance Upgrade
DB2 Logs
DB2 Partition Support Product
DB2 Tools
Default Tablespaces
DRDA Data Load
Event Monitors
Explain Plan Interpretation
Explain Plan Tools
Global Session Temp Tables
I/O Cleaners
Initialize Monitors
Isolation Level
Mobile Computing Product
Product Connectivity
Restore - Authority
Rollforward Recovery
SMS Tablespace
SMS Tablespace Properties
SQL Views
SYSCAT Tablespace
System Tables
System Temp Tablespace
Table Privileges
Tablespace Containers
Time Zone Base Rollforward Recovery
Trusted Versus Un-trusted Clients
Turning Archive Log Mode
User Connection
User Temp Tablespace db Partition
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)