1z0-888 sample questions

Question 1

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?

Accepted Answer

-quick

Answer

-tab

Answer

-tab

Answer

-skip-buffer

Question 2

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

Accepted Answer

Use DROP USER ‘mike’@’client.example.com’;

Accepted Answer

Use GRANT USAGE ON *.* TO ‘mike’@’client.example.com’ MAX_USER_CONNECTIONS=0;

Answer

Use ALTER USER ‘mike’@’client.example.com’ PASSWORD EXPIRE;

Answer

Use REVOKE ALL PRIVILEGES FROM ‘mike’@’client.example.com’;

Answer

Execute the mysql_secure_installation command.

Answer

Use ALTER USER ‘mike’@’client.example.com’ ACCOUNT LOCK;

Question 3

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

Accepted Answer

It is the default location for all new tables that you create.

Accepted Answer

It contains the system tablespace.

Answer

It contains the binary log.

Answer

It contains a general tablespace.

Answer

It contains the redo log.

Answer

It contains the undo log.

Question 4

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

Accepted Answer

Use mysql_config_editor, which allows you to store encrypted login credentials in your home directory.

Accepted Answer

Use the password validation plugin available to improve user name and password strength.

Answer

Store your password in an option file eg: -/.my.cnf and use -defaults-file so that it is read and used. [client] password=t100043va

Answer

Connect through the --socket rather than the default -protocol=TCP for local connection. $ mysqldump -u backupuser -h 127.0.0.1 -pt100043va living - socket=/tmp/mysql.sock > /backups/latest.sql

Question 5

The accountjoe@example.com has been created with privileges, as shown in the output: The accountjane@example.com exists. The account mary@example.com does not exist. Which three statements will succeed when executed byjoe@example.com? (Choose three.)

Accepted Answer

CREATE USER mary@example.com IDENTIFIED BY ,AjkK2@9bqLm4!jlaN';

Accepted Answer

GRANT INSERT ON audit.* TO jane@example.com;

Accepted Answer

GRANT DELETE ON world.* TO jane@example.com;

Answer

GRANT SELECT ON audit.* TO jane@example.com;

Answer

GRANT SELECT ON world.* TO joe@example.com;

Answer

GRANT SELECT ON world.* TO mary@example.com IDENTIFIED BY 'AjkK2@9bqLm4!jlaN';

Answer

GRANT SELECT ON world.* TO jane@example.com;

Question 6

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?

Accepted Answer

The access is available immediately.

Answer

The access does not take effect until the user logs out and back in.

Answer

The access does not take effect until the next time the server is started.

Answer

The access does not take effect until you issue the FLUSH PRIVILEGES statement.

Question 7

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

Accepted Answer

innodb_log_file_size

Accepted Answer

max_user_connections

Accepted Answer

port

Answer

innodb_buffer_pool_size

Answer

max_connections

Answer

join_buffer_size

Answer

character_set_system

Question 8

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

Accepted Answer

The PROCESS privilege is required.

Accepted Answer

The events_statements_current consumer must be enabled.

Accepted Answer

The threads table contains all the required columns.

Answer

The performance impact is less than SHOW FULL PROCESSLIST.

Answer

A connection must be instrumented to be included in the list of processes.

Answer

The sys.session view provides the process list with additional information.

Question 9

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

Accepted Answer

They are used to set up the initial binary log files.

Accepted Answer

They are used to set up a replication slave.

Accepted Answer

They are used to recover data.

Answer

They are used to prevent data corruption.

Answer

They are used to prevent data theft.

Answer

They are used to set up a test system.

Question 10

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

Accepted Answer

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

Accepted Answer

There is a redundant index on the emp_no column.

Answer

There are three indexes on the table.

Answer

There is a redundant index on the dept_no column.

Answer

The values on the emp_no column must be unique.

Answer

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

1z0-888 Sample Questions & Answers

Ready for the real thing?

1z0-888 Sample Questions & Answers

Related practice tests

Ready for the real thing?