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 Price: | Approx. $200 USD |
| Real Exam Qty: | 60 - 99 |
| Available Languages: | English |
| Certificate Validity Period: | Lifetime (no expiration) |
| Exam Format: | Multiple choice, Scenario-based, Drag and drop |
| Related Certifications: | IBM Certified Database Associate IBM Certified Database Developer |
| Passing Score: | 60% - 70% |
| Exam Duration: | 90 minutes |
| Recommended Training: | IBM DB2 9.5 SQL Procedure Development Training IBM DB2 9.5 SQL PL Reference Guide |
| 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 |
|---|---|---|
| Creating and Managing SQL Procedures | 25% | - Input/output parameters - Modifying and dropping procedures - External procedures and modules - CREATE PROCEDURE syntax |
| SQL Procedure Fundamentals | 20% | - Control flow statements - Variables, data types, and declarations - SQL PL basics and syntax - Error handling and conditions |
| Performance and Optimization | 20% | - Monitoring and tuning - DB2 9.5 specific optimizations - Best practices for SQL procedures - Query optimization |
| Advanced SQL PL Structures | 20% | - User-defined functions - Cursors and result sets - Dynamic SQL - Triggers and event handling |
| Debugging and Testing | 15% | - Debugging techniques - Testing procedures - Analyzing execution flow |
By Alma
