IBM C2090-543 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| XML Data Manipulation | -Given a scenario, demonstrate knowledge of XML schema validation XML schema evolution -Demonstrate the ability to use XML functions
-Given a scenario, demonstrate knowledge of how to use XQuery expressions and evaluate the results | 15% |
| 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
-Demonstrate knowledge of cursors
-Given a scenario, demonstrate the ability to manipulate large objects
| 32% |
| Database Objects | -Demonstrate knowledge of naming conventions of DB2 objects
-Describe when to use SQL routines, functions and modules
-Demonstrate knowledge of data types
| 11% |
| Advanced Programming | -Given a scenario, describe how to create and register external stored procedures -Given a scenario, describe how to create external functions
-Given a scenario, demonstrate knowledge of how changing data will work when referential constraints are involved
| 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)
-Demonstrate the ability to submit an SQL statement
-Describe how to manipulate result sets
-Demonstrate knowledge of problem determination
| 27% |
IBM DB2 Application Development Exam Certification Details:
| Duration | 90 mins |
| Exam Name | IBM Certified Application Developer - DB2 9.7 for Linux, Unix and Windows |
| Exam Code | C2090-543 |
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM DB2 Application Development Sample Questions |
| Exam Price | $200 (USD) |
| Passing Score | 60% |
| Number of Questions | 60 |
We're so confident of our products that we provide no hassle product exchange.


By Honey

