Free 1z0-888 sample questions
These free 1Z0-888 sample questions come from the retired MySQL 5.7 DBA exam, with answers and explanations. They cover server setup, user security, backups and replication. If you plan to certify now, study for 1Z0-908 instead.
Try them in the simulator Same questions, with study, timed and flashcard modes.
Showing 10 of 20 free sample questions.
Which three options are most likely to be changed for production form their default values? (Choose three.)
You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST. Which three statements are true? (Choose three.)
What three are correct statements about MySQL backups? (Choose three.)
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.)

You are remotely logged in to MySQL as the user “backup”. The account has temporarily been granted full privileges WITH GRANT to perform the actions required. You want to change the password for the locally existing “backup” user. Select the three commands which will perform the required action. (Choose three.)
A particular government’s security policy is to have very strict data encryption and safety settings. This is done by restricting access based on their own CA authority and limiting access to particular users within a department. Which method could be used to restrict access as required?
An administrator installs MySQL to run under a mysql OS account. The administrator decides to disable logins to the mysql account by using /nologin or /bin/false as the user’s shell setting. Which statement is true?
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
Which storage option for MySQL data directory typically offers the worst performance in a highly concurrent, OLTP-heavy, IO-bound workload?
10 more free samples are waiting
Create a free account to unlock the whole 1z0-888 sample bank, or get full access to all 358 practice questions in the simulator.