C2090-543 Exam Information and Guideline
DB2 9.7 Application Development
Below are complete topics detail with latest syllabus and course outline, that will help you good knowledge about exam objectives and topics that you have to prepare. These contents are covered in questions and answers pool of exam.
Exam Title :
IBM Certified Application Developer - DB2 9.7 for Linux Unix and Windows
Exam ID :
C2090-543
Exam Duration :
90 mins
Questions in Exam :
60
Passing Score :
60%
Exam Center :
Pearson VUE
Real Questions :
IBM DB2 Application Development Real Questions
VCE Practice Test :
IBM C2090-543 Certification VCE Practice Test
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%
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%
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%
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%