1Z0-918 MySQL Database Administration Professional — Exam Overview
Quick Facts
The 1Z0-918 exam earns the MySQL Database Administration Certified Professional credential. It is a multiple-choice exam of 70 questions taken in 120 minutes, with a passing score of 60%. Results are shown on screen at the close of the exam and can be reviewed afterwards in Oracle CertView.
Who this exam is for
The certification is aimed at MySQL database administrators who install, secure, monitor, tune, back up and keep MySQL servers highly available in production.
Exam Domains
Understanding MySQL Architecture, Storage, and InnoDB Fundamentals
Understand MySQL architecture, connectivity and storage fundamentals, and manage InnoDB storage structures and memory usage.
Managing MySQL Server Installation, Startup, Configuration, Upgrade, and Multiple Server Instances
Install, initialise and maintain a MySQL server environment, and configure and manage MySQL runtime behaviour and multiple instances.
Administering MySQL Security, Authentication, Authorization, Encryption, and Firewall Controls
Manage MySQL identities, authentication and access control, assess and secure server, host and connection environments, and implement advanced data protection and threat prevention controls.
Monitoring MySQL Activity, Analysing Operations, and Maintaining Stability
Monitor, audit and analyse MySQL activity, and evaluate and maintain MySQL performance, capacity and stability.
Optimizing MySQL Queries Through Analysis, Indexing, and Statistics
Analyse MySQL query processing and identify optimisation opportunities, and improve query performance using index design and index statistics.
Managing MySQL Backup and Recovery Methods, Tools, and Strategies
Plan and evaluate MySQL backup approaches and strategy, and implement backup and recovery operations using appropriate tools and methods.
Managing MySQL High Availability Using Replication, Monitoring, InnoDB Cluster, and Recovery
Understand MySQL replication concepts and high-availability architecture, configure, manage and monitor replication, and implement and recover InnoDB Cluster environments.
Preparing for 1Z0-918
Work through the practice questions in study mode first, read every explanation, then switch to timed practice. Oracle publishes the topic list for this exam without percentage weightings, and the practice questions spread across every topic area — Administering MySQL Security, Authentication, Authorization, Encryption, and Firewall Controls is the largest area in this practice bank — and revisit the topics you score lowest on until your practice scores are consistent.
Write Your Review on 1Z0-918 MySQL Database Administration Professional
1Z0-918 Customer Reviews
No reviews yet
Be the first to share your experience with this exam.