PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free 1Z0-908 Practice Questions

Pass your Oracle MySQL 8.0 Database Administrator (1Z0-908) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
Not published Pass Rate
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Which log records every successful and failed connection attempt and every executed statement (when enabled), regardless of duration?

A
B
C
D
to track
Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

Oracle DBA

Practice Questions

Oracle SQL

Practice Questions

OCI 2025 Data Science Professional (1Z0-1110-25)

Practice Questions
2026 Statistics

Key Facts: 1Z0-908 Exam

73

Multiple-Choice Questions

Oracle

120 min

Time Limit

Oracle

62%

Passing Score

Oracle

$245

Exam Fee (USD)

Oracle 2026

7

Topic Areas

Oracle 1Z0-908 outline

8.0.18

Validated Version

Oracle

The Oracle 1Z0-908 MySQL 8.0 Database Administrator exam consists of 73 multiple-choice questions over 120 minutes with a 62% pass mark and a $245 USD fee, validated against MySQL 8.0.18. Topics span architecture, installation, security, monitoring, query optimization, backup and recovery, and high availability (Group Replication and InnoDB Cluster).

Sample 1Z0-908 Practice Questions

Try these sample questions to test your 1Z0-908 exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which storage engine is the default for new tables created in MySQL 8.0?
A.MyISAM
B.InnoDB
C.MEMORY
D.CSV
Explanation: InnoDB has been the default storage engine since MySQL 5.5 and remains the default in MySQL 8.0. It supports ACID transactions, row-level locking, foreign keys, and crash recovery via the redo log.
2Which InnoDB structure caches data and index pages in memory to reduce disk I/O?
A.Redo log buffer
B.Doublewrite buffer
C.Buffer pool
D.Change buffer
Explanation: The InnoDB buffer pool caches table and index pages in memory. Its size is controlled by innodb_buffer_pool_size, and on dedicated DB hosts it is typically tuned to 50-75% of system RAM.
3In MySQL 8.0, where is metadata about tables, columns, and indexes stored?
A.In .frm files alongside the table data
B.In a transactional InnoDB data dictionary inside mysql.ibd
C.Only in INFORMATION_SCHEMA tables on disk
D.In a MyISAM system table named mysql.tables
Explanation: MySQL 8.0 introduced the transactional data dictionary stored in InnoDB tables inside the mysql.ibd tablespace. The legacy .frm, .par, .trg, and .trn files were removed.
4Which file does InnoDB use to apply changes during crash recovery?
A.The binary log
B.The undo log
C.The redo log (ib_logfile)
D.The general query log
Explanation: The redo log (ib_logfile0/ib_logfile1, or #innodb_redo files in newer 8.0 releases) records page-level changes. After a crash, InnoDB replays committed redo records to bring data files up to date.
5Which client connection protocol allows a local client on the same host as the server to connect without TCP/IP overhead on Unix-like systems?
A.Named pipe
B.Shared memory
C.Unix socket file
D.X Protocol over TLS
Explanation: On Unix-like systems, local clients connect through a Unix socket file (default /tmp/mysql.sock or as set by the socket variable) when host is localhost, bypassing TCP/IP.
6An InnoDB table is created without an explicit PRIMARY KEY but has a UNIQUE NOT NULL column. How does InnoDB choose the clustered index?
A.It refuses to create the table
B.It uses the first UNIQUE NOT NULL index as the clustered index
C.It always generates a hidden 6-byte ROWID
D.It clusters on the first column declared in the table
Explanation: InnoDB uses the explicit PRIMARY KEY when present; otherwise it promotes the first UNIQUE index whose columns are all NOT NULL. Only when neither exists does it generate a hidden 6-byte clustered key (GEN_CLUST_INDEX).
7Which InnoDB feature reduces random secondary-index I/O by deferring updates to non-unique secondary index pages not in the buffer pool?
A.Adaptive hash index
B.Change buffer
C.Doublewrite buffer
D.Insert buffer pool
Explanation: The change buffer caches insert, update, and delete operations to non-unique secondary index pages that are not in the buffer pool. Changes are merged when the page is later read in.
8Which variable controls the size of the InnoDB buffer pool?
A.innodb_log_file_size
B.innodb_buffer_pool_size
C.key_buffer_size
D.innodb_redo_log_capacity
Explanation: innodb_buffer_pool_size sets total buffer pool memory. In 8.0 it can be resized dynamically while the server is running.
9Where do undo logs reside by default in MySQL 8.0?
A.Inside the system tablespace ibdata1 only
B.In dedicated undo tablespaces (undo_001, undo_002) outside the system tablespace
C.In the binary log
D.In .ibd files of each user table
Explanation: In MySQL 8.0 undo logs live in two default undo tablespaces (undo_001 and undo_002) that are independent of ibdata1. Additional undo tablespaces can be created and truncated online.
10Which view exposes per-table size, row count estimates, and engine information using the new data dictionary?
A.INFORMATION_SCHEMA.TABLES
B.performance_schema.global_status
C.mysql.table_stats
D.sys.host_summary
Explanation: INFORMATION_SCHEMA.TABLES is a view over the data dictionary and reports the engine, row estimates, average row length, data length, and index length for each table.

About the 1Z0-908 Exam

1Z0-908 is the OCP-level certification for MySQL 8.0 Database Administrators. It validates the ability to install and configure MySQL 8.0, secure user accounts and data, monitor and tune performance, manage backups and point-in-time recovery, and operate high-availability topologies including Group Replication and InnoDB Cluster.

Questions

73 scored questions

Time Limit

120 minutes

Passing Score

62%

Exam Fee

$245 USD (Oracle University (delivered by Pearson VUE))

1Z0-908 Exam Content Outline

~13%

Architecture

Client connections, MySQL data storage, InnoDB on-disk and in-memory structures, buffer pool and caches, and the transactional data dictionary.

~14%

Server Installation and Configuration

Binary, RPM, and Docker installations; option files; system variables (global vs session, dynamic vs static, SET PERSIST); startup, shutdown, upgrade; multiple instances.

~19%

Security

Users, roles, authentication plugins (caching_sha2_password, LDAP), password policy, account locking, TLS, X.509, MySQL Enterprise Firewall and Audit, TDE, SQL injection prevention.

~12%

Monitoring and Maintenance

Error, general, slow, and binary logs; Performance Schema and sys; SHOW PROCESSLIST and ENGINE INNODB STATUS; lock troubleshooting; MySQL Enterprise Monitor and Audit.

~11%

Query Optimization

Optimizer behavior, EXPLAIN and EXPLAIN ANALYZE, optimizer hints, B-tree, descending, functional, and multi-valued indexes, partitioning, and online vs INSTANT DDL.

~13%

Backups and Recovery

Logical backups (mysqldump, mysqlpump, MySQL Shell util.dumpInstance), physical backups (MySQL Enterprise Backup), binary log archival, and point-in-time recovery.

~18%

High Availability

Asynchronous, semisynchronous, and GTID-based replication, multi-source replication, replication threads and filters, Group Replication, InnoDB Cluster, ClusterSet, ReplicaSet, and MySQL Router.

How to Pass the 1Z0-908 Exam

What You Need to Know

  • Passing score: 62%
  • Exam length: 73 questions
  • Time limit: 120 minutes
  • Exam fee: $245 USD

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

1Z0-908 Study Tips from Top Performers

1Build a MySQL 8.0 sandbox and practice ALTER USER, GRANT/REVOKE, and role activation to internalize the security syllabus.
2Configure GTID-based replication, multi-source replication, and Group Replication on a 3-node cluster using MySQL Shell AdminAPI.
3Practice point-in-time recovery: take mysqldump --single-transaction --master-data=2, simulate a bad transaction, and replay binary logs with mysqlbinlog --stop-position.
4Memorize key system variables: innodb_buffer_pool_size, innodb_flush_log_at_trx_commit, sync_binlog, binlog_format, binlog_expire_logs_seconds.
5Use EXPLAIN ANALYZE on slow queries and study Performance Schema and sys schema views (statement_analysis, innodb_lock_waits, replication_group_members).

Frequently Asked Questions

What is the Oracle 1Z0-908 exam format?

The 1Z0-908 exam consists of 73 multiple-choice questions delivered over 120 minutes through Pearson VUE testing centers or online proctoring. The passing score is 62% and the exam is validated for MySQL 8.0.18.

How much does the 1Z0-908 exam cost?

The 1Z0-908 exam fee is $245 USD per attempt. Retakes are billed at the same $245 rate. Pricing in other regions varies based on Oracle's regional schedule.

What topics does the 1Z0-908 exam cover?

1Z0-908 covers seven topic areas: Architecture, Server Installation and Configuration, Security, Monitoring and Maintenance, Query Optimization, Backups and Recovery, and High Availability. High Availability includes replication, Group Replication, and InnoDB Cluster.

Are there prerequisites for the 1Z0-908 exam?

There are no formal prerequisites. Oracle recommends hands-on MySQL 8.0 DBA experience plus the Become a MySQL 8.0 Database Admin Professional learning path. Most candidates need 40-80 hours of focused study.

How should I study for the 1Z0-908 exam?

Focus on the highest-weight areas: Security (~19%), High Availability (~18%), Server Installation and Configuration (~14%), Architecture (~13%), and Backups and Recovery (~13%). Practice on a real MySQL 8.0 sandbox: configure replication, build an InnoDB Cluster with MySQL Shell, run mysqldump and MySQL Enterprise Backup, and walk through PITR with mysqlbinlog.

What is the difference between 1Z0-908 and 1Z0-909?

1Z0-908 is the MySQL 8.0 Database Administrator OCP exam targeting DBAs. 1Z0-909 is the MySQL 8.0 Database Developer OCP exam targeting application developers and covers schema objects, queries, transactions, stored programs, and connectors instead of operations and HA.