1Z0-888: MySQL 5.7 Database Administrator

Full Name: MySQL 5.7 Database Administrator

Exam Code: 1Z0-888

Try Sample Exam »

Oracle 1Z0-888 Exam Details:

Exam Name	MySQL 5.7 Database Administrator
Exam Code	1Z0-888
Exam Product Version	Oracle Database 12c
Exam Price	USD $245 (Pricing may vary by country or by localized currency)
Duration	120 minutes
Number of Questions	75
Passing Score	58%
Recommended Training	MySQL for Database Administrators Ed 4 Oracle Certified Professional, MySQL 5.7 Database Administrator MySQL Learning Subscription Unlimited Learning Subscription - All Technology
Recommended Training	Oracle Certified Professional, MySQL 5.7 Database Administrator (OCP)
Recommended Practice	1Z0-888 Online Practice Exam

Oracle 1Z0-888 Syllabus Topics

Installing MySQL	- Install MySQL - Identify installed Files and Directories - Understand Initial Configuration - Start and Stop MySQL
MySQL Architecture	- Understand How MySQL Processes Requests - Explain How MySQL Stores Data - Use Tablespaces - Identify Redo and Undo Logs - Define How MySQL Uses Memory
Configuring MySQL	- Understand Server Options, Variables, and the Command Line - Define Option Files - Use System Variables
Monitoring MySQL	- Monitor MySQL with Log Files - Monitor MySQL with Status Variables - Monitor MySQL with Performance Schema
User Management	- Identify MySQL Privilege System - Create and Modify User Accounts - Configure Passwords and Account Expiration - Understand Authentication Plug-Ins - Grant Permissions - Reset a Forgotten Root Password
MySQL Security	- Identify Security Risks - Understand Network security - Use Password Security - Explain Operating System Security - Protect Against SQL Injections
Maintaining a Stable System	- Define Stability - Use Capacity Planning - Troubleshoot - Identify the Causes of Server Slowdowns - Describe InnoDB Recovery
Optimizing Query Performance	- Identify Slow Queries - Understand the EXPLAIN statement - Work with Indexes - Use Index Statistics
Backup Strategies	- Understand Backups - Create a Backup Strategy - Use MySQL Backup Tools - Define Raw Backup Methods - Explain Techniques that Use the Binary Log
Configuring a Replication Topology	- Replicate Conflicts - Explain Replication - Configure Replication - Use MySQL Utilities - Identify Replication Threads - Monitor Replication - Troubleshoot Replication