Oracle MySQL 8.0 Database Administrator - 1Z0-908 Exam Questions [2026]

QUESTION NO: 1
Which two are use cases of MySQL asynchronous replication? (Choose two.)

A. You can scale reads by adding multiple slaves. B. MySQL Enterprise Backup will automatically back up from an available slave. C. It allows backup to be done on the slave without impacting the master. D. It guarantees near real-time replication between a master and a slave. E. You can scale writes by creating a replicated mesh.

Correct Answer: A,C

QUESTION NO: 2
Examine this snippet from the binary log file named binlog.000036:

The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?

A. mysqlbinlog --stop-datetime='2019-ll-20 14:55:18' binlog.000036 | mysql B. mysqlbinlog --stop-position=500324 binlog.000036 | mysql C. mysqlbinlog --stop-position=5004S3 binlog.000036 | mysql D. mysqlbinlog --stop-datetime='2019-ll-20 14:55:16' binlog.000036 | mysql

Correct Answer: D

QUESTION NO: 3
Your MySQL instance is capturing a huge amount of financial transactions every day in the finance database.
Company policy is to create a backup every day.
The main tables being updated are prefixed with transactions-.
These tables are archived into tables that are prefixed with archives- each month. mysqlbackup
--optimistic-busy-tables="^finance\.transactions-.*" backup
Which optimization process best describes what happens with the redo logs?

A. The redo logs are backed up first, then the transaction and archive tables. B. The redo logs are backed up only if there are changes showing for the transactions tables. C. The redo logs are not backed up at all. D. The transaction tables are backed up first, then the archive tables and redo logs. E. The archive tables are backed up first, then the transaction tables and redo logs.

Correct Answer: B

QUESTION NO: 4
Which three are requirements for a secure MySQL Server environment? (Choose three.)

A. Run MySQL server as the root user to prevent incorrect sudo settings. B. Encrypt the file system to avoid needing exact file-system permissions. C. Ensure appropriate file system privileges for OS users and groups. D. Keep the entire software stack on one OS host. E. Minimize the number of non-MySQL Server-related processes running on the server host. F. Restrict the number of OS users that have access at the OS level.

Correct Answer: B,C,D

QUESTION NO: 5
You encountered an insufficient privilege error in the middle of a long transaction.
The database administrator is informed and immediately grants the required privilege:
GRANT UPDATE ON world.city TO 'user1';
How can you proceed with your transaction with the least interruption?

A. Roll back the transaction and start the transaction again in the same session. B. Close the connection, reconnect, and start the transaction again. C. Change the default database and re-execute the failed statement in your transaction. D. Re-execute the failed statement in your transaction.

Correct Answer: D

QUESTION NO: 6
A user wants to connect without entering his or her username and password on the Linux command prompt.
Which three locations can be used to store the user's mysql credentials to satisfy this requirement? (Choose three.)

A. $MYSQL_HOME/my.cnf file B. DATADIR/mysqld-auto.cnf file C. $HOME/.my.cnf file D. $HOME/.mysqlrc file E. $HOME/.mysql/auth/login file F. /etc/my.cnf file G. $HOME/.mylogin.cnf file

Correct Answer: A,B,F

QUESTION NO: 7
You are having performance issues with MySQL instances. Those servers are monitored with MySQL Enterprise Monitor.
Using Query Analyzer, where do you begin to look for problem queries?

A. Look for queries with big prolonged spikes in row activity/access graph in the times series graph. B. Sort the "Exec" column and check for SQL queries with low Query Response Time index (QRTi) values. C. Sort the "Exec" column and check for SQL queries with high Query Response Time index (QRTi) values. D. Look for queries with low total latency times in the Latency section in the times series graph.

Correct Answer: A

QUESTION NO: 8
Which three sets of item information are visible in the mysql system database? (Choose three.)

A. time zone information and definitions B. information about table structures C. help topics D. audit log events E. plugins F. rollback segments G. performance monitoring information

Correct Answer: C,E,F

QUESTION NO: 9
Which two statements are true about InnoDB data-at-rest encryption? (Choose two.)

A. It enforces encryption from disk to memory and over network transmission. B. It supports only non-blob datatypes. C. It supports all indexes transparently. D. It does not support the transportable tablespaces feature. E. It decrypts data for use in memory.

Correct Answer: C,E