Free 1z0-888 Oracle Updates

MySQL 5.7 Database Administrator Questions and Answers

Question 17

Which two statements are true about InnoDB auto-increment locking? (Choose two.)

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.

Question 18

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.