We're so confident of our products that we provide no hassle product exchange.
MYSQL 1Z0-872 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | MySQL 5.0 Developer Certified Professional Exam, Part II |
| Exam Number: | 1Z0-872 |
| Exam Price: | $195–$300 USD |
| Exam Duration: | 90 minutes |
| Exam Format: | Multiple Choice, Single Answer, Multiple Answer |
| Available Languages: | English |
| Real Exam Qty: | 70 |
| Certificate Validity Period: | Lifetime (non-expiring, retired exam) |
| Passing Score: | 60% |
| Related Certifications: | Oracle Certified Professional, MySQL 5 Developer (requires 1Z0-871 + 1Z0-872) |
| Recommended Training: | Oracle University MySQL 5 Developer Training MySQL 5.0 Reference Manual |
| Exam Registration: | Oracle University Certification Pearson VUE (historical registration) |
| Sample Questions: | MYSQL 1Z0-872 Sample Questions |
| Exam Way: | In-person proctored at Pearson VUE test centers only; exam is retired and no longer available for new registration |
| Pre Condition: | Recommended to complete 1Z0-871 (MySQL 5.0 Developer Part I) first; no strict prerequisite |
| Official Syllabus URL: | https://education.oracle.com/ |
MYSQL 1Z0-872 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Indexes and Optimization | 10% | - Index types and creation - Using EXPLAIN to analyze queries - Query optimization basics |
| Topic 2: Triggers and Events | 10% | - Scheduling and managing events - Managing and dropping triggers - Creating triggers for INSERT/UPDATE/DELETE |
| Topic 3: Transactions and Locking | 15% | - Table-level and row-level locking - ACID properties - Deadlock detection and resolution - Isolation levels |
| Topic 4: Advanced Queries & Joins | 25% | - Multi-table joins - UNION, UNION ALL, and set operations - Subqueries and nested queries - Complex filtering and sorting |
| Topic 5: Data Manipulation | 20% | - Using prepared statements - Handling transactions and commits - Insert, Update, and Delete operations |
| Topic 6: Stored Routines | 20% | - Creating and using stored procedures - Debugging and error handling - Parameters, variables, and flow control - Creating and using user-defined functions |
By Carol
