ExamDumpster

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.

Question 1Choose one

You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table. Which statement describes the activation of that access for the user?

Question 2Choose 3

Which three options are most likely to be changed for production form their default values? (Choose three.)

Question 3Choose 3

You want to use the Performance Schema to get the equivalent of SHOW FULL PROCESSLIST. Which three statements are true? (Choose three.)

Question 4Choose 3

What three are correct statements about MySQL backups? (Choose three.)

Question 5Choose 2

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.)

Question 6Choose 3

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.)

Question 7Choose one

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?

Question 8Choose one

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?

Question 9Choose 2

You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)

Question 10Choose one

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.

Create account