Test Center

It is easy to see the newest titles that have been added to the test library. Go to the Test Center and click "View All Free Tests". The list will include the latest tests. Come see what is new and measure your skills!

DB2 Programming

Description:

Our DB2 Programming test measures your knowledge of programming DB2 databases. Designed for experienced programmers, this test covers the following topics: Adding/Changing Data, Data Access, Data Definition and Data Types, Error Handling, Locking, Concurrency, and Unit of Work, Multiple Table Access, Performance Considerations, SQL Functions, Stored Procedures and User Defined Functions.

This test is associated with a Job Role. Please visit the Job Role Center for more details.

$49.95

Once you request a test, your Personal Identification Number (PIN) will be stored in your My Plan for easy access. You will have 90 days in which to take the test you requested.

Test Outline

Adding / Changing Data
Column Constraints and Triggers
Insert Data
Modify Existing Records
Referential Integrity
Update Cursors
Data Access
Cursor Declaration
Matching Selection Criteria
Ordering and Grouping
Range Selection
Data Definition and Data Types
Catalog Tables
Date / Time Formats
Special Types
Table Definition
Use of Data Types
Error Handling
Common Error Codes
SQL Condition Handlers
SQLCODE vs SQLSTATE
Locking, Concurrency, and Unit of Work
Commit and Rollback
Isolation Levels
Lock Types and Granularity
Multiple Table Access
Inner and Outer Joins
Nested Table Expressions
Subselects
Union
Performance Considerations
Index Definition
Index Usage
Static vs. Dynamic SQL
SQL Functions
Aggregate Functions
Column Functions
Date / Time Functions
Using Special Registers
Stored Procedures & User Defined Functions
Creating Functions and Procedures
Passing Parameters
Result Sets