C2090-556: Informix 11.50 Application Developer

Full Name: Informix 11.50 Application Developer

Exam Code: C2090-556

Try Sample Exam »

IBM Informix Application Developer Exam Summary:

Exam Name	IBM Certified Application Developer - Informix 11.50
Exam Code	C2090-556
Exam Price	$200 (USD)
Duration	90 mins
Number of Questions	58
Passing Score	60%
Books / Training	IBM Informix v11.50 Information Center
Sample Questions	IBM Informix Application Developer Sample Questions
Practice Exam	IBM C2090-556 Certification Practice Exam

IBM C2090-556 Exam Syllabus Topics:

Topic (Weights)	Details
Database Objects (16%)	- Demonstrate knowledge of database objects - Describe when to use SQL routines, functions and modules - Demonstrate knowledge of data types
Traditional Data Manipulation (30%)	- Demonstrate knowledge of privileges needed to access data in an application - Describe the differences between dynamic and static SQL - Demonstrate knowledge of distributed queries - Given a scenario, demonstrate knowledge of changing data - Demonstrate knowledge of cursors - Given a scenario, demonstrate the ability to manipulate large objects - Knowledge of built-in functions
SPL Programming (14%)	- Core concepts - Core functionality - Triggers - Error Handling in SPL routines
Core Concepts(24%)	- Demonstrate knowledge of the difference between SQLI and Distributed Relational Database Architecture (DRDA) - Demonstrate the ability to submit an SQL statement - Describe how to manipulate result sets - Demonstrate knowledge of problem determination - Demonstrate knowledge of isolation levels, locks and logging
Extensibility (16%)	- Demonstrate knowledge of existing database extensions - Demonstrate knowledge of UDTs - How to create functions to support UDTs - Demonstrate knowledge of casting - Demonstrate knowledge of Access Methods