1Z0-908 practice examsIn development

Oracle Certified Professional, MySQL Database Administrator

Oracle · advanced · 120 minutes

In developmentThis course is still being brought to our full standard. The questions and notes are usable, but they have not yet been checked line by line against the vendor’s own training.

Administering the database that runs a large share of the web: the pluggable storage engine layer and why InnoDB is the only sensible choice, the clustered primary key that every secondary index carries, configuration that survives a restart, accounts as user and host pairs, then logical against physical backup with binary log replay for point-in-time recovery, row-based replication with global transaction identifiers, InnoDB Cluster with its router, and ranking queries by total time rather than worst case.

What you get

198practice questions

3full papers of 65

2course chapters · 13 minutes

100%answers explained

Papers are cut from the bank and weighted like the real exam, and no question appears in two of them. Every wrong answer comes back on later days until you have it right.

What the exam covers

The domains our question bank is built on. We have not yet transcribed this vendor’s own outline for this exam.

Architecture, InnoDB, configuration and security	Not published
Backup, replication, high availability and performance	Not published

Two sample questions

Two of the 198, with the answer and the explanation.

1. What does MySQL Router give an application?

A cache of query results for read scaling
One endpoint that follows the cluster's current primary — correct
A proxy that rewrites the application's queries
A firewall filtering which clients may connect

Why: Without it the application would have to discover the new primary itself after every failover.

2. What does the account host part restrict?

Where it connects from — correct
The account password
The granted role
The storage engine

Why: The host part restricts which client hosts the user may connect from.

The real 1Z0-908 exam

Length	120 minutes
Questions	65
Pass mark	61%
Price	Purchased per attempt through Oracle University
Recommended before you sit it	None enforced. Production MySQL administration experience is assumed.
Valid for	Does not expire, though it is tied to the release examined

Exam facts as published by Oracle; always check the vendor’s page before you book.

Study 1Z0-908 with Chiron

Chiron is invitation-only while we are in beta, and nothing is for sale yet: invited accounts use every paper, drill and course note for free.