IBM DB2 Application Development Exam Certification Details:
| Schedule Exam | Pearson VUE |
| Sample Questions | IBM DB2 Application Development Sample Questions |
| Exam Price | $200 (USD) |
| Number of Questions | 60 |
| Exam Name | IBM Certified Application Developer - DB2 9.7 for Linux, Unix and Windows |
| Passing Score | 60% |
| Duration | 90 mins |
| Exam Code | C2090-543 |
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% |
| 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% |
| 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% |
| 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% |
IBM A2090-543 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | DB2 9.7 Application Development |
| Exam Number: | C2090-543 |
| Related Certifications: | IBM Certified Database Administrator - DB2 9.7 IBM Certified Solution Developer - DB2 |
| Exam Format: | Multiple choice, Multiple response |
| Exam Price: | Varies by region (approximately 200-250 USD equivalent) |
| Real Exam Qty: | 50-70 |
| Passing Score: | 60-70% |
| Exam Duration: | 90-120 |
| Available Languages: | English |
| Certificate Validity Period: | Not formally expiring (legacy certification; subject to IBM certification program updates) |
| Recommended Training: | IBM DB2 9.7 Application Development Training |
| Exam Registration: | IBM Certification Portal |
| Sample Questions: | IBM A2090-543 Sample Questions |
| Exam Way: | Proctored exam via IBM authorized testing centers or online delivery (depending on availability) |
| Pre Condition: | No strict prerequisites; basic SQL and database knowledge recommended |
| Official Syllabus URL: | https://www.ibm.com/training/certification |
We're so confident of our products that we provide no hassle product exchange.


By Clement

