Oracle MySQL 5.7 Database Administrator - 1Z0-888 Free Exam Questions [2026]

QUESTION NO: 1
A general purpose MySQL instance is configured with the following options:
--slow-query-log
--long-query-time=.0001
--log-queries-not-using-indexes
--log-slow-admin-queries
--general-log
--log-bin
--binlog-format=STATEMENT
--innodb-flush-log-at-trx-commit=1
Which three statements are true for most workloads? (Choose three.)

A. The Slow Query Log records more data than the Binary Log.

B. The Binary Log records more data than the Slow Query Log.

C. The Binary Log records more data than the General Query Log.

D. The Slow Query Log records more data than the General Query Log.

E. The General Query Log records more data than the Slow Query Log.

F. The General Query Log records more data than the Binary Log.

Discussion 0

Correct Answer: A,E,F Vote an answer

QUESTION NO: 2
You have a consistent InnoDB backup created with mysqldump, the largest table is 50 GB in size.
You start to restore your backup with this command;
shell> mysql -u root -p < backup.sql
After 30 minutes, you notice that the rate of restore seems to have slowed down. No other processes or external factors are affecting server performance.
Which is the most likely explanation for this slowdown?

A. The MySQL server has stopped inserting data to check index consistency.

B. InnoDB is doing CRC32 checks over the tablespace data as it grows.

C. InnoDB has filled the redo log and now must flush the pages.

D. Secondary indexes no longer fit into the buffer pool.

E. The MySQL server is taking a periodical snapshot of data so it can resume the restore if it is interrupted mid-way.

Discussion 0

Correct Answer: A Vote an answer

QUESTION NO: 3
Which MySQL utility copies the master instance to a slave instance on the same host?

A. mysqldbcopy

B. mysqlfailover

C. mysqlrplsync

D. mysqlserverclone

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 4
Consider a replication setup where a snapshot of the replication status shows:

Which statement is true?

A. The melbourne channel is keeping up with the received events.

B. The last event received from the sydney channel was at 2018-05-08 14:55:01.

C. The melbourne channel is resolving a GTID conflict.

D. The replication slave uses multisource replication with eight sources.

E. The sydney channel is keeping up with the received events.

Discussion 0

Correct Answer: D Vote an answer

QUESTION NO: 5
Which statement is true about using Microsoft Windows Cluster as a platform for MySQL?

A. It is provided by means of IP-level disk replication.

B. It relies on the shared disk architecture being visible to both servers.

C. It implements High Availability by using the NET Connector's load balancing capabilities.

D. It is a shared-nothing architecture.

Discussion 0

Correct Answer: B Vote an answer

QUESTION NO: 6
Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query?

A. There is a redundant index on the emp_no column.

B. The secondary indexes are optimized for unique key look-ups.

C. The selectivity of the dept_no column is the best of the indexed columns.

D. There are three indexes on the table.

E. The values on the emp_no column must be unique.

F. There is a redundant index on the dept_no column.

Discussion 0

Correct Answer: A,B Vote an answer

QUESTION NO: 7
An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data.
The SHOW SLAVE STATUSindicates these values:
* RELAY_LOG_FILE=hostname-relay-bin.00004
* RELAY_LOG_POS=1383
Which command set would make the slave current?

A. STOP SLAVE; SET GLOBAL master_delay=0; START SLAVE;

B. STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = `hostname-relay-bin.00004', RELAY_LOG_POS = 1383;

C. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE;

D. STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; RELAY_LOG_FILE = `hostname-relay- bin.00004', RELAY_LOG_POS = 1383;

Discussion 0

Correct Answer: C Vote an answer

QUESTION NO: 8
Why should you be selective when granting the PROCESS privilege to an account?

A. It allows the use of stored routines.

B. It allows a client to see another user's queries with the SHOW PROCESSLIST command.

C. It allows a client to control running processes on a server.

D. It allows a client to process scripts.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 9
Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer?

A. The join buffer is set per connection.

B. The join buffer is global and can be changed only by restarting the server.

C. The value should be increased from the default if the query joins large rows without using an index.

D. The join buffer is used to process sorts when complex joins are being performed.

E. The value should be increased if the client performs several SELECT operations.

Discussion 0

Correct Answer: C,D Vote an answer

QUESTION NO: 10
Group Replication uses global transaction identifiers to track executed transactions and are fundamental in avoiding transaction conflict. Which additional three steps help in avoiding conflicts in group replication?

A. Guarantee a primary key on every table.

B. Use the binary log row format.

C. Set multiple slave parallel worker threads.

D. Set isolation level to be READ COMMITTED.

E. Configure IPv6 network for hosts.

F. Set isolation level to be SERIALIZABLE.

G. Guarantee a secondary index on every table.

Discussion 0

Correct Answer: A,B,F Vote an answer

QUESTION NO: 11
You are creating a strategy for backing up MySQL using a cold binary backup. The MySQL instance is a replication master with global transaction identifiers (GTIDs) enabled and it uses Transparent Data Encryption (TDE). Other than the configuration required to make the instance a replication master and enabled GTIDs and TDE, the instance is using all default settings.
The requirements for the backup are:
- It must be possible to rebuild the instance using the backup.
- It must be verified.
- It must allow for a catastrophic hardware failure.
Which four steps must be included in the backup strategy? (Choose four.)

A. Include the relay logs in the backup.

B. Restore the backup to a clean MySQL instance.

C. Include the MySQL PID file in the backup.

D. Include the operating system disk encryption key in the backup.

E. Include the binary logs in the backup.

F. Include the ibtmp1 file in the backup.

G. Include the keyring data and/or configuration in the backup.

H. Copy the backup to a remote host.

I. Include the MySQL socket file in the backup.

Discussion 0

Correct Answer: A,C,D,H Vote an answer

QUESTION NO: 12
Given these table definitions and the explain plan:

Which ALTER TABLE statement will improve the performance of the query?

A. ALTER TABLE `Country` ADD INDEX `idx_NameCont` (`Name`, `CountryCode`);

B. ALTER TABLE `Country` ADD INDEX `idx_Code` (`Code`);

C. ALTER TABLE `CountryLanguage` ADD INDEX `idx_Lang` (`Language`);

D. ALTER TABLE `CountryLanguage` ADD INDEX `idx_OffLang` (`IsOfficial`, `Language`);

Discussion 0

Correct Answer: B Vote an answer

QUESTION NO: 13
What is the best method for monitoring Group Replication conflict resolution?

A. the INNODB Lock Monitor details

B. the SHOW STATUS command

C. the PERFORMANCE_SCHEMA tables

D. the INFORMATION_SCHEMA tables

E. the SHOW PROCESSLIST command

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).

QUESTION NO: 14
There are multiple instances of MySQL Server running on a single OS that is backed up using the mysqlbackup command.
The /etc/my/cnf contains default values, for example, datadir=/var/lib/mysql/, with extra instances having their own separate my.cnf file (for example /etc/mysql/instanceN.cnf) overriding the defaults. A restore of the second instance is attempted from the mysqlbackup archive using this command:
mysqlbackup --backup-dir=/opt/backup/mysql/instance2 copy-back
Upon starting the second MySQL instance, you notice that the data does not match the expected backup.
Which command-line option is required to successfully update the second instance?

A. --copy-back-from-log

B. --restore=2

C. --instance=/var/lib/mysql/instance2

D. --defaults-file=/etc/mysql/instance2.cnf

E. --backup-instance=/var/lib/mysql/instance2

Discussion 0

Correct Answer: D Vote an answer

QUALITY AND VALUE

Tested and Approved

Easy to Pass

Try Before Buy

RECENT DISCUSSIONS

Useful Links

Contact Us