MYSQL 1Z0-871 Exam Information and Actual Questions
- Exam Code/Number: 1Z0-871
- Exam Name/Title: MySQL 5.0 Developer Certified Professional Exam, Part I
- Certification Provider: MYSQL
- Corresponding Certification: MYSQL-Certifications
- Exam Questions: 69
- Updated On: Oct 07, 2026
1Z0-871
FREE EXAM DUMPS QUESTIONS & ANSWERS
MYSQL
1Z0-871 Exam
MySQL 5.0 Developer Certified Professional Exam, Part I
MYSQL 1Z0-871 Exam Overview:
| Certification Vendor: | Oracle (formerly MySQL AB / Sun Microsystems) |
|---|---|
| Exam Name: | MySQL 5.0 Developer Certified Professional Exam, Part I |
| Exam Number: | 1Z0-871 |
| Exam Duration: | 90 minutes |
| Passing Score: | 61% |
| Related Certifications: | MySQL 5.0 Developer Certified Professional Exam, Part II (1Z0-872) |
| Exam Format: | Multiple Choice, Scenario-based, Multiple Select |
| Real Exam Qty: | 69 |
| Exam Price: | $195 USD |
| Available Languages: | Japanese, English |
| Certificate Validity Period: | Retired, no longer valid for new candidates |
| Recommended Training: | MySQL 5.0 Certification Study Guide Oracle University MySQL Developer Training |
| Exam Registration: | Pearson VUE Registration |
| Sample Questions: | MYSQL 1Z0-871 Sample Questions |
| Exam Way: | Onsite at Pearson VUE test centers only; no online proctoring |
| Pre Condition: | No formal prerequisites; recommended 6+ months experience with SQL and MySQL |
| Official Syllabus URL: | https://education.oracle.com/ |
MYSQL 1Z0-871 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Relational Database Concepts & MySQL Architecture | 10% | - Relational database model - MySQL server architecture and components - Client-server communication |
| SQL Basics & Querying Data | 20% | - Using built-in functions and expressions - SELECT syntax and filtering - Working with NULL values - Sorting and limiting results |
| Metadata & Security Basics | 10% | - User accounts and privileges - Querying information schema - Basic security best practices |
| Data Types & Table Design | 15% | - Column attributes and constraints - Table creation, modification, and deletion - Indexing and primary/foreign keys - Numeric, string, and temporal data types |
| Joins & Subqueries | 15% | - Single-row and multi-row subqueries - INNER, LEFT, RIGHT, and FULL joins - Correlated subqueries - Combining result sets with UNION |
| Views & Stored Routines | 15% | - Creating and managing views - Stored procedures and functions - Using prepared statements - Triggers and events |
| Data Modification & Transactions | 15% | - Transaction control: COMMIT, ROLLBACK, SAVEPOINT - INSERT, UPDATE, DELETE statements - ACID properties and isolation levels |
0
0
0
10