1z0-888 Free Sample Questions

Consider the key buffer in a MySQL server. Which two statements are true about this feature? (Choose two.)

Consider the ANALYZE TABLE command. In which two situations should this command be used?

Which three statements correctly describe MySQL InnoDB Cluster? (Choose three.)

An admin attempts to enforce stronger security by using these commands: The admin then leaves the system running with the specified changes. What are two remaining security concerns? (Choose two.)

What two statements are true regarding FLUSH TABLES FOR EXPORT? (Choose two.)

You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?

You want to immediately stop access to a database server for remote user ‘mike’@’client.example.com’. This user is currently not connected to the server. Which two actions can you take to stop any access from the user? (Choose two.)

When you examine a new MySQL installation with default configuration, you find a file called ibdata 1 in the database directory. Which two statements are true about this file? (Choose two.)

You have a scheduled task on Linux that executes mysqldump against the localhost server periodically. When checking the logs of this event to ensure that things are working and that backups will restore, you notice an output that is concerning. The command the scheduled task is executing as follows: $ mysqldump -u backupuser-h 127.0.0.1 -pt100043va living -protocol=TCP > /backups/latest.sql Warning: Using a password on the command-line interface can be insecure. Which two methods are available to avoid the warning? (Choose two.)

The [email protected] has been created with privileges, as shown in the output: The [email protected] exists. The account [email protected] does not exist. Which three statements will succeed when executed [email protected]? (Choose three.)