The official MYSQL MySQL 5.0, 5.1 and 5.5 Certified Associate outline defines 6 domains. The leading three are Backup, Recovery and Maintenance, User Management and Security, and Database Design and SQL. The full list is in the topics section above, and TestKingsIT's 240 practice questions cover each one.

No strict prerequisites, but basic SQL and database knowledge is recommended Since requirements change over time, confirm the latest on the official MYSQL exam page before scheduling.

The official MYSQL page publishes the current question count and duration; review it before your test date.

MYSQL recommends these training resources for the MYSQL MySQL 5.0, 5.1 and 5.5 Certified Associate exam:

Follow the training with steady self-testing — the 240 practice questions from TestKingsIT help you apply theory and fill any gaps the training leaves.

TestKingsIT issues a full refund if you take the MYSQL MySQL 5.0, 5.1 and 5.5 Certified Associate exam within 60 days of purchase and do not pass. The policy does not apply if the exam is taken within 3 days of purchase, if the exam was never actually taken, or to free materials or expired orders, and the candidate name must match the payer name. Submit a scan of your enrollment slip and the official Score Report PDF within 2 days of the exam; claims are processed within 7 days. Alternatively, exchange for two free exam products of equal value and keep your original update service. Orders arrive by email within 1 minute — contact support if nothing arrives within 2 hours.

Three versions of the same study materials: a printable, expert-prepared PDF with free demo download and instant access; a Desktop Test Engine for Windows with customizable simulation and timed modes that works offline; and an Online Test Engine for any browser on Windows, Mac, Android, and iOS with test history and performance review — not limited to any equipment, and friendly even without a network. All 240 practice questions are identical across versions. Every purchase includes 365 days of free updates, a 50% renewal discount afterward, and unlimited computer installations.

The 1Z0-870 exam is a MYSQL certification exam validating the MYSQL MySQL 5.0, 5.1 and 5.5 Certified Associate syllabus shown above. It belongs to these credential paths: Oracle Certified Associate, MySQL 5 DBA. Candidates in 2026 start with TestKingsIT's 240 practice questions, available as a printable PDF, a Windows Desktop Test Engine, and an Online Test Engine — three versions of the same materials.

Scoring and fees are published by MYSQL and may change; verify the current figures on the official site.

Proctored exam (online or test center depending on provider availability) Register for the MYSQL MySQL 5.0, 5.1 and 5.5 Certified Associate exam through these official channels:

After booking, TestKingsIT delivers your practice questions within 1 minute — preparation starts the same day.