DB2 5.x DBA Assessment

  • $10.00


DB2 is a strategic product from IBM that is available on all of IBM's key platforms. This database is predicated on the relational model, which is founded on the mathematics of set theory. This provides a solid theoretical base for the management of data. The DB2 5.x DBA assessment is appropriate to be given to database administrators.

Assessments for ADABAS DBA, Oracle Applications DBA and SQL Server 2000 DBA are also available.

Number of questions 60
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered DB2 Internals
DB2 Performance
Problem Resolution
SQL
Utilities and Commands
Vocabulary
Tasks tested Analysis
Arranging Data
Backup Utilities
BIND Parameters
Cartesian Product
Catalog Manipulation
CHECK DATA Utility
Consolidating Data
Control and Administration
Convert Number to String
Correlated Subqueries
Cursors
DASD Volumes
Data Access
Data Consistency
Data Modification in Embedded SQL
Data Modification with Cursors
Data Organization
DATE Function
DB2 Data Structures
DB2 Utilities
DBAS
Debugging SQL
Determine Number of Rows
Embedded SQL
EXPLAIN Feature
GROUP BY and HAVING
Identify Code
Identify SQL Technique
Identify Structure
Joins
LENGTH Function
Lock Acquisition Failure
Lock Management
Locking Strategy Components
Miscellaneous Utilities
Most Valuable Trace
Number of Locks
OCCURS Clause
OPEN Cursors
Operator
Physical Storage
Referential Constraints
Reset Check Pending
Retrieve all Rows
Search Criteria
SELECT
Specific Trace Types
SQL Techniques
Stored Procedures
STRIP Function
Tablespace Lock
Trace Types
Tune Database Designs
UNION Clause
Valid Lock Types
VALUE Function
WITH UR Clause
Writing Traces
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)