1z0-888 sample questions

Question 1

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

Accepted Answer

It caches index blocks for MylSAM tables only.

Accepted Answer

It is set on a per-connection basis.

Answer

It caches index blocks for all storage engine tables.

Answer

It is a global buffer.

Answer

It caches index blocks for InnoDB tables only.

Question 2

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

Accepted Answer

when you want to update index distribution statistics

Accepted Answer

after large amounts of table data have changed

Answer

when you want to check a tables structure to see if it may have been damaged and needs repair

Answer

when you need to find out why a query is taking a long time to execute

Question 3

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

Accepted Answer

All MySQL client programs and connectors can be used for executing queries.

Accepted Answer

There is support for automatic failover when one node fails.

Accepted Answer

Each query will be executed in parallel across the nodes.

Answer

The cluster can be operated in multimaster mode with conflict detection for DML statements.

Answer

It provides fully synchronous replication between the nodes.

Answer

The data is automatically shared between the nodes.

Question 4

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

Accepted Answer

The name of the dictionary file is too obvious.

Accepted Answer

The dictionary file is in an insecure location.

Answer

validate_password_policy cannot be set without restarting the MySQL instance.

Answer

The dictionary file word list is too short.

Answer

validate_password_dictionary_file cannot be set without restarting the MySQL instance.

Answer

The validate_password plug-in has not been loaded.

Question 5

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

Accepted Answer

It can be used to export TEMPORARY tables.

Accepted Answer

Table only exports when the table has its own tablespace.

Answer

The InnoDB Storage engine must be used for the table being exported.

Answer

It is the safest way to extract tables from the shared tablespace.

Answer

Partitioned tables are not supported.

Question 6

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 7

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 8

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 9

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 10

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;

MySQL 5.7 Database Administrator Free Sample Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Lifetime One

Two

Pro Four

Premium Twelve

1z0-888 Sample Questions

Trusted by professionals at