DB2 Developer Assessment

$16.00

DB2 Developer Assessment

$16.00
description

DB2 is a relational database used on many platforms. This test is designed to measure the skills used in programming for DB2 on an IBM mainframe. This DB2 Developer test covers both version 4 and version 5. For DB2 administrators, please see the related DB2 DBA test. Tests for SQL Server 2000 DBA and Oracle Applications DBA are also available.

 

Number of questions 36
Competencies tested SQL Coding
DB2 in General
Programming Practices
Program Preparation
COBOL Programming
CICS Programming
COBOL Coding
Tasks tested COMMIT with Cursors
Valid SELECT Statements
Naming Columns
Multiple Select Statements
GROUP BY Clause
Inner Joins
SELECT with Cursors
SPUFI Comments
Handling NULL Values
Value Returned
SUBSTR Function
SQL CODE
LIKE Clauses
Data Types
Multiple Statements in SPUFI
UNION and UNION ALL
Definitions
VIEW Usage
Naming Conventions
Cursor Usage
Deadlocks
Referential Integrity
SQLCODE
Testing SQL
COMMIT Frequency
DCLGEN Function
Precompiler
DB2 Precompiler
Hard-Coded SQL
NULL Value in VARCHAR
Using a Variable Table Name
COBOL Column Processing
COBOL SQL Statements
Table Specification
Browsing
Host Variables