QUESTION: 17

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

Answer(s): C,E,F

Reference:

https://dev.mysql.com/doc/refman/5.6/en/memory-use.html

Show Answer Next Question

QUESTION: 18

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.

Answer(s): B

Show Answer Next Question

QUESTION: 19

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.

Answer(s): E,F

Reference:

https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html

Show Answer Next Question

You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?

Run the create_system_tables.sql file
Run the mysql_unpack.sql file
Invoke mysqld with the --initialize option.
Invoke mysql with the --initialize option.

Answer(s): C

Reference:

https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization-mysqld.html

Show Answer Next Question

Free Oracle 1z0-888 Exam Braindumps (page: 6)

QUESTION: 17

Reference:

QUESTION: 18

QUESTION: 19

Reference:

QUESTION: 20

Reference:

1z0-888 Exam Discussions & Posts