DB2 Developer Assessment

  • $10.00


DB2 is a relational database used on many platforms. This assessment is designed to measure the skills used in programming for DB2 on an IBM mainframe. This DB2 Developer assessment covers both version 4 and version 5. For DB2 administrators, please see the related DB2 DBA test.

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

Number of questions 36
Test format Multiple-Choice
Time to complete Varies by skill
Topics covered CICS Programming
COBOL Coding
COBOL Programming
DB2 in General
Program Preparation
Programming Practices
SQL Coding
Tasks tested Browsing
COBOL Column Processing
COBOL SQL Statements
COMMIT Frequency
COMMIT with Cursors
Cursor Usage
Data Types
DB2 Precompiler
DCLGEN Function
Deadlocks
Definitions
GROUP BY Clause
Handling NULL Values
Hard-Coded SQL
Host Variables
Inner Joins
LIKE Clauses
Multiple Select Statements
Multiple Statements in SPUFI
Naming Columns
Naming Conventions
NULL Value in VARCHAR
Precompiler
Referential Integrity
SELECT with Cursors
SPUFI Comments
SQL CODE
SQLCODE
SUBSTR Function
Table Specification
Testing SQL
UNION and UNION ALL
Using a Variable Table Name
Valid SELECT Statements
Value Returned
VIEW Usage
Supported languages ๐Ÿ‡บ๐Ÿ‡ธ English (en_US)