IBM DB2 Application Development Exam Certification Details:
| Number of Questions | 60 |
| Passing Score | 60% |
| Exam Code | C2090-543 |
| Schedule Exam | Pearson VUE |
| Exam Name | IBM Certified Application Developer - DB2 9.7 for Linux, Unix and Windows |
| Exam Price | $200 (USD) |
| Duration | 90 mins |
| Sample Questions | IBM DB2 Application Development Sample Questions |
IBM C2090-543 Exam Syllabus Topics:
| Topic | Details | Weights |
|---|---|---|
| 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% |
| 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% |
| 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% |
| 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% |














0 Customer Reviews
Quality and ValueITCertKing Practice Exams are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development - no all study materials.
Tested and ApprovedWe are committed to the process of vendor and third party approvals. We believe professionals and executives alike deserve the confidence of quality coverage these authorizations provide.
Easy to PassIf you prepare for the exams using our ITCertKing testing engine, It is easy to succeed for all certifications in the first attempt. You don't have to deal with all dumps or any free torrent / rapidshare all stuff.
Try Before BuyITCertKing offers free demo of each product. You can check out the interface, question quality and usability of our practice exams before you decide to buy.
