Download Oracle.1z0-888.TestInside.2019-07-13.42q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-888 |
| Exam Name: | MySQL 5.7 Database Administrator |
| Date: | Jul 13, 2019 |
| File Size: | 977 KB |
Demo Questions
Question 1
Which three allocate memory per thread in MySQL? (Choose three.)
- query cache
- thread cache
- read buffer
- internal temporary table
- sort buffer
- InnoDB buffer pool instance
Correct answer: CEF
Explanation:
Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html Reference: https://dev.mysql.com/doc/refman/5.6/en/memory-use.html
Question 2
Suppose you are adding rows to a MyISAM table and the --datadir location runs out of disk space. What will happen when this occurs?
- The server will crash.
- The server suspends that INSERT operation until space becomes available.
- An error message will be returned to the client .Server Error: ER_IO
- The server suspends operations for all storage engines until space becomes available.
Correct answer: B
Question 3
The MySQL installation includes the mysql_config_editor utility for managing login paths stored in a .mylogin.cnf file.
Which two are true about the login path feature? (Choose two.)
- mysql_config_editor is the only MySQL-provided utility that can print the values stored in .mylogin.cnf.
- A .mylogin.cnf file can store at most one login path.
- It provides a FIPS-compliant keyring for storing MySQL login details.
- A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.
- It is an alternative to storing the MySQL login details in a my.cnf file.
- It provides means to help avoid accidentally exposing the MySQL login details.
Correct answer: EF
Explanation:
Reference: https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html Reference: https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
