1z0-888 Exam Dumps : MySQL 5.7 Database Administrator

It stores data in .MYD files and its index and undo information in the common tablespace.

It stores data in .MYD files, index information in .MYI files, and undo information the common tablespace.

It stores its data in tablespace file(s). Index and data dictionary details are stored in .FRM files.

It stores its data, index and undo information in .MYD and .MYI files.

It stores data, index and undo information in tablespace file(s).

InnoDB never uses table-level locks.

InnoDB always protects auto-increment updates with a table-level lock

InnoDB does not use locks to enforce auto-increment uniqueness.

The auto-increment lock can be a table-level lock.

Some settings for innodb_autoinc_lock_mode can help reduce locking.

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.