Exam Domains
Architecture Architecture
Weight not published
- 1.1Configure client connections to the server
- 1.2Understand how MySQL stores data
- 1.3Understand how InnoDB stores data and logs
- 1.4Configure buffers and caches
- 1.5Understand and use the Data Dictionary
Server Installation and Configuration Server Installation and Configuration
Weight not published
- 2.1Install and use the MySQL server and client programs
- 2.2Identify the files and folders created during installation
- 2.3Start and stop MySQL
- 2.4Upgrade MySQL
- 2.5Configure MySQL by using options and option files
- 2.6Configure MySQL variables
- 2.7Launch multiple MySQL servers on the same host
Security Security
Weight not published
- 3.1Create user accounts and roles
- 3.2Use authentication plug-ins
- 3.3Control user and role permissions
- 3.4Recognize common security risks
- 3.5Secure MySQL server connections
- 3.6Provide password and login security
- 3.7Secure the MySQL host environment
- 3.8Prevent SQL injection attacks
- 3.9Encrypt MySQL data
- 3.10Configure MySQL Enterprise Firewall
Monitoring and Maintenance Monitoring and Maintenance
Weight not published
- 4.1Configure and view MySQL log files
- 4.2Monitor MySQL processes and status
- 4.3Configure MySQL Enterprise Audit
- 4.4Use MySQL Enterprise Monitor to view activity in MySQL
- 4.5Monitor database growth and explain capacity planning
- 4.6Troubleshoot problems with locked resources
Query Optimization Query Optimization
Weight not published
- 5.1Examine how MySQL optimizes queries
- 5.2Analyze queries with MySQL Enterprise Monitor
- 5.3Create indexes to improve server performance
- 5.4Monitor and understand index statistics
Backups and Recovery Backups and Recovery
Weight not published
- 6.1Distinguish between the different types of backup
- 6.2Implement a backup strategy
- 6.3Backup and restore data with MySQL Enterprise Backup
- 6.4Use mysqldump and mysqlpump to perform logical backups
- 6.5Explain when and how to use raw file backups
- 6.6Back up the binary log
High Availability Techniques High Availability Techniques
Weight not published
- 7.1Explain how replication provides high availability and scalability
- 7.2Configure replication
- 7.3Explain the role of the binary log in replication
- 7.4Configure multisource replication
- 7.5Explain the role of replication threads
- 7.6Monitor and troubleshoot replication
- 7.7Describe MySQL InnoDB cluster and Group Replication
- 7.8Configure a MySQL InnoDB cluster
- 7.9Perform an InnoDB cluster recovery
Exam Details
Question TypesMultiple Choice, Multiple Select
FormatLinear
Online ProctoringAvailable
ID RequirementsOne valid government-issued photo ID with full name. Name must match Pearson VUE registration exactly.
RenewalNot required -- Oracle certifications are version-specific. When Oracle releases a new database/platform version, a new exam version is typically released. Previous certifications remain valid as earned.
Retake Policy14-day waiting period after failed attempt. Maximum 3 attempts per exam in a 12-month period. Full exam fee required for each retake.
LanguagesEnglish, Brazilian Portuguese, Simplified Chinese, Japanese, Korean, Spanish