C2090-543 Exam Dumps

IBM DB2 9.7 Application Development C2090-543 real exam questions and online practice test engine by FreeCram. Try C2090-543 exam questions for free. You can also download a free demo of the C2090-543 exam PDF version.

IBM's C2090-543 actual exam materials brought to you by FreeCram group of IBM certification experts.
View all C2090-543 actual exam questions & answers and explanations for free.

If you like our product, you can request full access to all the latest IBM DB2 9.7 Application Development C2090-543 exam premium questions.

Certification Provider:	IBM
Exam Code / Number:	C2090-543
Exam Name:	DB2 9.7 Application Development
Exam Questions:	100
Last Updated:	Jun 18, 2026
Corresponding Certification:	IBM certifications I

Go To C2090-543 Questions

(234 Up Votes)

IBM DB2 Application Development Exam Certification Details:

Schedule Exam	Pearson VUE
Exam Price	$200 (USD)
Exam Name	IBM Certified Application Developer - DB2 9.7 for Linux, Unix and Windows
Passing Score	60%
Sample Questions	IBM DB2 Application Development Sample Questions
Exam Code	C2090-543
Duration	90 mins
Number of Questions	60

IBM C2090-543 Exam Syllabus Topics:

Topic	Details	Weights
Traditional Data Manipulation	-Demonstrate knowledge of authorities needed to access data in an application -Describe the differences between dynamic and static SQL -Demonstrate knowledge of how to query databases across multiple tables and views -Given a scenario, demonstrate knowledge of changing data Insert Update Delete -Demonstrate knowledge of cursors Types of cursors Read only Updatable Scrollable Scope of cursors Create and manipulate cursors -Given a scenario, demonstrate the ability to manipulate large objects Locators -Demonstrate the ability to manage a unit of work Isolation levels COMMIT ROLLBACK SAVEPOINT	32%
Advanced Programming	-Given a scenario, describe how to create and register external stored procedures -Given a scenario, describe how to create external functions OLE DB table External table -Given a scenario, demonstrate knowledge of how changing data will work when referential constraints are involved -Demonstrate knowledge of distributed unit of work (two phase commit) -Demonstrate knowledge of trusted contexts -Demonstrate knowledge of using advanced database objects Global declared temporary tables Sequences MQTs	15%
Database Objects	-Demonstrate knowledge of naming conventions of DB2 objects Aliases Views Tables -Describe when to use SQL routines, functions and modules How to use DB2's built-in routines Functions Stored procedures -Demonstrate knowledge of data types Integer Floating point Strings Date/time LOBs XML data type	11%
XML Data Manipulation	-Given a scenario, demonstrate knowledge of XML schema validation XML schema evolution -Demonstrate the ability to use XML functions XMLPARSE Whitespace handling XMLSERIALIZE XMLTRANSFORM Functions for preparing XML documents from relational data -Given a scenario, demonstrate knowledge of how to use XQuery expressions and evaluate the results -Given a scenario, describe how to construct queries that retrieve both traditional and XML data	15%
Core Concepts	-Describe how to bind and rebind a package -Given a scenario, demonstrate knowledge of using parameter markers -Demonstrate knowledge of how to connect to a database (may use scenarios) JDBC ADO.NET CLI/ODBC php_ibm_db2 Embedded SQL -Demonstrate the ability to submit an SQL statement JDBC ADO.NET CLI/ODBC php_ibm_db2 Embedded SQL -Describe how to manipulate result sets JDBC ADO.NET CLI/ODBC php_ibm_db2 Embedded SQL -Demonstrate knowledge of problem determination JDBC ADO.NET CLI/ODBC php_ibm_db2 Embedded SQL	27%