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














522 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.
