We're so confident of our products that we provide no hassle product exchange.
IBM C2090-735 Exam Overview:
| Certification Vendor: | IBM |
| Exam Name: | DB2 9.5 SQL Procedure Developer |
| Exam Number: | C2090-735 (also known as 000-735) |
| Exam Format: | Multiple choice, Scenario-based, Drag and drop |
| Passing Score: | 60% - 70% |
| Related Certifications: | IBM Certified Database Associate IBM Certified Database Developer |
| Exam Duration: | 90 minutes |
| Certificate Validity Period: | Lifetime (no expiration) |
| Exam Price: | Approx. $200 USD |
| Real Exam Qty: | 60 - 99 |
| Available Languages: | English |
| Recommended Training: | IBM DB2 9.5 SQL PL Reference Guide IBM DB2 9.5 SQL Procedure Development Training |
| Exam Registration: | Pearson VUE IBM Certification Portal |
| Sample Questions: | IBM C2090-735 Sample Questions |
| Exam Way: | Proctored at Pearson VUE test centers or online proctored; retired exam no longer available for new registration |
| Pre Condition: | No formal prerequisites; recommended hands-on experience with DB2 9.5 and SQL PL development |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM C2090-735 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Advanced SQL PL Structures | 20% | - Dynamic SQL - Cursors and result sets - User-defined functions - Triggers and event handling |
| Debugging and Testing | 15% | - Debugging techniques - Testing procedures - Analyzing execution flow |
| Creating and Managing SQL Procedures | 25% | - External procedures and modules - Modifying and dropping procedures - Input/output parameters - CREATE PROCEDURE syntax |
| SQL Procedure Fundamentals | 20% | - Error handling and conditions - Control flow statements - Variables, data types, and declarations - SQL PL basics and syntax |
| Performance and Optimization | 20% | - Best practices for SQL procedures - DB2 9.5 specific optimizations - Query optimization - Monitoring and tuning |
By Ward
