DB2 5.x DBA Assessment

$16.00

DB2 5.x DBA Assessment

$16.00
description

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 test is appropriate to be given to database administrators.

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

 

Total Questions 60
Question Types Multiple Choice
Competencies Tested Vocabulary
Problem Resolution
SQL
DB2 Internals
DB2 Performance
Utilities and Commands
Tasks Tested EXPLAIN Feature
Joins
Data Access
Embedded SQL
UNION Clause
Search Criteria
Referential Constraints
Debugging SQL
OCCURS Clause
Convert Number to String
Correlated Subqueries
Data Modification with Cursors
Consolidating Data
STRIP Function
SELECT
Cursors
Determine Number of Rows
Stored Procedures
DB2 Data Structures
Identify SQL Technique
Identify Structure
LENGTH Function
Cartesian Product
Data Modification in Embedded SQL
DATE Function
SQL Techniques
Operator
Retrieve all Rows
OPEN Cursors
Identify Code
VALUE Function
GROUP BY and HAVING
Arranging Data
Control and Administration
BIND Parameters
Number of Locks
DASD Volumes
Lock Management
Physical Storage
DBAS
Lock Acquisition Failure
Locking Strategy Components
Valid Lock Types
WITH UR Clause
Tablespace Lock
Most Valuable Trace
Writing Traces
Analysis
Specific Trace Types
Tune Database Designs
Trace Types
DB2 Utilities
Miscellaneous Utilities
Backup Utilities
CHECK DATA Utility
Data Consistency
Catalog Manipulation
Reset Check Pending
Data Organization