File Info
| Exam | MySQL 5.7 Database Administrator |
| Number | 1z0-888 |
| File Name | Oracle.1z0-888.TestInside.2019-07-13.42q.tqb |
| Size | 977 KB |
| Posted | Jul 13, 2019 |
| Download | Oracle.1z0-888.TestInside.2019-07-13.42q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
