IBM


IBM Professional Certification Program

Accelerate insight. Improve skills. Get certified now.

Test C2090-556: Informix 11.50 Application Developer


cert assess save

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



Promotions


Connect with Us