1z0-888 Free Practice Test

The MySQL error log shows:
InnoDB: Warning: a long semaphore wait:
The relevant parts of the InnoDB monitor output shows:
<>

1. A. Increase the value of the innodb_lock_wait_timeout option.
2. B. Increase the value of the innodb_read_io_threads option.
3. C. Change the table to use HASH indexes instead of BTREE indexes.
4. D. Set the value of innodb_adaptive_hash_index to zero.
5. E. Deactivate the query cache.
6. F. Increase the size of the InnoDB buffer poo

Correct Answer: BF

To satisfy a security requirement, you have created or altered some user accounts to include REQUIRE X509.
Which additional task needs to be performed for those user accounts to fulfill the requirement to use X509?

1. A. Install the X509 plug-in on the server.
2. B. Set the X509 option in the [client] section of the MySQL server’s configuration file.
3. C. Restart the server with the --require-x509 option.
4. D. Distribute client digital certificates to the client computers being used to log in by the user accounts.
5. E. Provide users access to the server’s private ke

Correct Answer: B

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time?

1. A. mysqldumpslow
2. B. mysqldump
3. C. mysqlaccess
4. D. mysqlshow
5. E. mysqlslow

Correct Answer: A

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?

1. A. The mysql user needs a login and its home directory must be the base directory of the installation.
2. B. The OS needs to allow logging in as mysql so that administrative tasks can be performed.
3. C. This prevents mysqld from starting when standard startup scripts are used.
4. D. This prevents creation of a command shell with the mysql account, while allowing mysqld to ru

Correct Answer: A

Consider that local disk files are accessible via MySQL with commands such as: mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords; What change could be made to stop any breach via this insecurity?

1. A. executing REVOKE LOADFROM *.*
2. B. setting the --local-service=0 option when starting mysqld
3. C. executing REVOKEFILEFROM *_*
4. D. executing REVOKEFILE ON *_* FROM ‘ ‘@’%’
5. E. setting the --local-infile=0 option when starting mysqld
6. F. setting the --open-files-limit=0 option when starting mysqld

Correct Answer: F