1z0-888 Oracle MySQL 5.7 Database Administrator Free Practice Exam Questions (2025 Updated)
Prepare effectively for your Oracle 1z0-888 MySQL 5.7 Database Administrator certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.
You have created a backup of the ‘sales’ database with the command:
Which two procedures can be used to restore the ‘orders’ table from the backup?
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
You have created a new user with this statement:
CREATE USER ‘erika’@’localhost’ IDENTIFIED BY ‘first#1Pass’ PASSWORD EXPIRE;
What is the outcome?
Is it true that binary backups always take less space than text backups?
Consider the CHECK TABLE command.
In which two situations should this command be used? (Choose two.)
On a master server that is using statement-based replication, a table of log data has become very large.
You decide to delete 100,000 rows.
Which two methods can be independently invoked to ensure that the delete is properly propagated to the slave? (Choose two.)
Which two statements are true regarding MySQL security? (Choose two.)
You are setting up a new installation of MySQL Server 5.7 (a GA release.) You have used a ZIP or TAR package to ensure that the mysqld binary, along with its support files, such as plug-ins and error messages, now exist on the host. Assume that the default datadir exists on the host. You installed the binary in the default location (the default --basedir value) for your operating system.
Which step should you perform before defining your own databases and database tables?
You are receiving complaints from your application administrators that they are seeing periodic stalls in database response (no queries to any table are returning results for several seconds or longer). You monitor your system and notice that the durations of those stalls correspond to peaks in disk I/O.
Which 2 things should you investigate?
Which are three facts about backups with mysqldump? (Choose three.)
Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)
A MySQL instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ.
Which two will optimize the security of this setup? (Choose two.)
A MySQL Server has been running an existing application successfully for six months. The my.cnf is adjusted to contain this additional configuration:
The MySQL Server is restarted without error.
What effect will the new configuration have on existing account?
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? (Choose two.)
How does the InnoDB storage engine handle deadlocks when they are detected?
Which two methods will provide the total number of partitions on a table? (Choose two.)
You have a config file for a running DB with this excerpt:
[mysqld]
tmp_table_size=16M
sort_buffer_size=256k
To address a query performance problem of connecting to the DB from an application on another host, you log in and make these changes to the DB:
mysql> SET GLOBAL tmp_table_size=32000000;
mysql> SET sort_buffer_size=2000000;
This solves the problem with your queries. However, later the DB instance is restarted and the performance problem returns.
Which three best describe this scenario?
