OpenExamsFREE PRACTICE — ANY EXAM

MySQL 8.0 Database Developer Oracle Certified Professional — Requirements & Free Practice

US · License preparation

100 free questions · Answer explanations · No signup required

Loading selected examination banks…

Choose what to practice

Start with an exam below. Your examination requirements depend on your application pathway. View licensing requirements

Licenses, application pathways and examination requirements

Each license and applicant pathway has its own requirements and exemptions. Choosing practice questions does not determine your eligibility.

MySQL 8.0 Database Developer Oracle Certified Professional

Oracle professional certification recognizing MySQL 8.0 application-development skills, including connectors, schema objects, transactions, query optimization, stored programs, and JSON/document stores.

Licensing authority: Oracle

Initial by examination
MySQL 8.0 Database Developer
Admission
Use a personal desktop/laptop with reliable internet, microphone and webcam. Government-issued ID must exactly match the registered first and last names; have two acceptable IDs if further validation is requested. Check in 30 minutes before the appointment. Be alone in a quiet room, do not speak, and have no access to prohibited devices, materials or screens; headphones and virtual backgrounds are prohibited.
Appointments
Proctored online, candidate-selected appointment via MyLearn. The requested 2026-11-25 through 2027-02-28 window is subject to actual available seats and attempt validity; no particular future seat was booked or verified and no institutional sitting is published in these materials.
Award
Register, attend and pass MySQL 8.0 Database Developer (1Z0-909) to receive the associated credential; the adopted path identifies this single real certification examination.
Changes
Reschedule or cancel at least 24 hours before the appointment; late cancellation risks forfeiture of the attempt.
Date Boundaries
Current examination, learning path and linked program materials were verified in this run. No official subject-specific start or retirement boundary was published in the examined materials or located in targeted official retirement searches; dates remain null, without claiming permanent availability. No other version, upgrade or alternative code is inferred.
Export Restrictions
The linked program policy restricts payment/exam delivery for nationals of export-restricted countries/regions, identifies Cuba, Iran, North Korea, Syria and Crimea and special restrictions for citizens of Venezuela, and provides documented case-by-case consideration for qualifying permanent residents, approved asylees and specified dual citizens. Permanent-residence exceptions do not override remaining export-licensing restrictions; apply the actual policy and documentation to the applicant, rather than treating US scope as an eligibility waiver.
Preparation
The examination page expressly marks the recommended course optional and recommends training plus hands-on experience. Courses and the practice module in the learning path are not additional certification examinations. The hidden generic 80%-completion dialog does not establish an active requirement for this exam and does not override the exam-specific optional-training statement.
Registration
A MyLearn account and purchased Oracle Exam Learning Subscription/attempt are used for registration. Registration, cancellation and rescheduling must remain within the attempt subscription's validity; the catalogue states six months to take the exam.

MySQL 8.0 Database Developer

Provider
Oracle University
Format
Proctored Online; Multiple Choice
Exam questions
Total questions: 65.
Time limit
90 Minutes
Passing score
62%
Examination outline
  • Connectors and APIs
    • Choose between connectors for a given application
    • Demonstrate connector use, management and configuration
    • Retrieve data from the database by using a connector
    • Handle special values
    • Secure credentials and connections
  • Data-driven Applications
    • Use prepared statements
    • Set SQL Modes to change MySQL behavior
    • Handle and interpret errors and warnings
    • Display query results
    • Aggregate and summarize data
    • Advanced Report Generation
  • MySQL Schema Objects and Data
    • Design, create, and alter views
    • Store and process string data
    • Store and process numeric data
    • Store and process temporal data
    • Store and process spatial data
  • Transactions
    • Control transactions in SQL
    • Control transactions in applications
    • Resolve consistency problems with isolation levels
    • Understand locking mechanisms within MySQL
  • Query Optimization
    • Use indexes for optimization
    • Analyze queries for optimization
    • Rewrite queries for optimization
  • MySQL Stored Programs
    • Create and execute stored routines
    • Explain the programming constructs used in stored routines
    • Create and execute triggers
    • Schedule database operations
  • JSON and Document Store
    • Create and store JSON documents
    • Process data in JSON documents
    • Explain application development with NoSQL and XDevAPI
    • Create and access a document store
    • Use MySQL Shell to access document stores
Examination sources