1Z0-909
OCP MySQL 8.0 Database Developer practice test
200 Oracle 1Z0-909 practice questions with explanations, in study, timed and flashcard modes. 20 sample questions are free.
Full access
$99
- All 200 questions, with explanations
- Study, timed and flashcard modes
- Progress saved, resume any time
- Questions
- 200
- Free samples
- 20
- Versions
- 1
- Updated
- Jan 2026
Exam simulator
Practice 1Z0-909 in the simulator.
Study, timed and flashcard modes. Answers and explanations as you go, and your progress saves.
At a glance
1Z0-909, by the numbers.
Official specifications published by Oracle.
- Duration
- 90 min
- Questions
- 65
- Passing score
- 62%
- Valid for
- Lifetime (does not expire)

Exam guide
Everything about 1Z0-909.
1Z0-909 · Oracle · v1.0
What is 1Z0-909?
1Z0-909 is a professional-level MySQL 8.0 exam for developers who build applications on MySQL. Passing it earns the MySQL 8.0 Database Developer Oracle Certified Professional title. Backend developers and database programmers usually take it. A connector is the driver that lets code in a language such as Java or Python talk to MySQL. The exam asks you to use connectors, control transactions, tune queries and write stored programs. For example, you might pick the isolation level that stops one transaction from reading another's unfinished changes. Its practice questions focus on these areas, plus views, data types and JSON documents.
What you'll practise
- Choose and configure a MySQL connector, then query data through it.
- Use prepared statements, set SQL modes and handle errors and warnings.
- Design views and store string and numeric data correctly.
- Control transactions in SQL and in application code.
- Speed up queries with indexes, query analysis and rewrites.
- Write stored routines and triggers, and work with JSON documents and the X DevAPI.
Requirements
- No formal prerequisites: anyone can book the exam.
- Recommended: hands-on experience with MySQL 8.0 and SQL programming.
- Recommended: knowledge of at least one programming language, such as Java or Python.
Who it's for
- MySQL database developers and database programmers.
- Backend and application developers whose apps store data in MySQL.
- Software engineers who write SQL and stored routines.
Exam details
Published by Oracle, plus what is in our question bank.
What does 1Z0-909 cover?
The practice test's questions, grouped by exam topic. Open a topic to see what it covers.
7 topics · 31 subtopics · 200 questions
How do I earn this certification?
Passing 1Z0-909 earns the MySQL 8.0 Database Developer Oracle Certified Professional in the MySQL Developer track.
How to study for this exam?
Use the 1Z0-909 practice test alongside the official material below.
What's changed on this exam?
Status and coverage changes that affect what you should study.
- Current status
- ACTIVE
Three ways to practise
Study mode
Work through the bank at your own pace with the answer and explanation one tap away. Flag questions, add notes, bookmark the hard ones.
Open in the simulatorTimed mode
A shuffled deck with a countdown that mirrors the real exam. Your score is saved to your attempt history.
Open in the simulatorFlashcards
Question on the front, answer on the back. Good for the last week before the exam.
Open in the simulator