Test 000-556: Informix 11.50 Application Developer

The test contains six sections totalling approximately 58 multiple-choice questions.  The percentages after each section title reflect the approximate distribution of the total question set across the sections.

Section 1 - Database Objects (16%)

1. Demonstrate knowledge of database objects
2. Describe when to use SQL routines, functions and modules
3. Demonstrate knowledge of data types

Section 2 - Traditional Data Manipulation (31%)

1. Demonstrate knowledge of privileges needed to access data in an application
2. Describe the differences between dynamic and static SQL
3. Demonstrate knowledge of distributed queries
4. Given a scenario, demonstrate knowledge of changing data
5. Demonstrate knowledge of cursors
6. Given a scenario, demonstrate the ability to manipulate large objects
7. Knowledge of built-in functions

Section 3 - SPL Programming (14%)

1. Core concepts
2. Core functionality
3. Triggers
4. Error Handling in SPL routines

Section 4 - Core Concepts (24%)

1. Demonstrate knowledge of the difference between SQLI and Distributed Relational Database Architecture (DRDA)
2. Demonstrate the ability to submit an SQL statement
3. Describe how to manipulate result sets
4. Demonstrate knowledge of problem determination
5. Demonstrate knowledge of isolation levels, locks and logging

Section 5 - Extensibility (16%)

1. Demonstrate knowledge of existing database extensions
2. Demonstrate knowledge of UDTs
3. How to create functions to support UDTs
4. Demonstrate knowledge of casting
5. Demonstrate knowledge of Access Methods