A.port

B.innodb_buffer_pool_size

C.join_buffer_size

D.max_user_connections

E.character_set_system

F.max_connections

G.innodb_log_file_size

A.Both the affected transactions will be rolled back.

B.The affected transactions wait for innodb_lock_wait_timeout seconds, and then roll back.

C.One of the affected transactions will be rolled back, the other is allowed to proceed.

D.The transaction isolation level determines which transaction is rolled back.

E.The innodb_locks_unsafe_for_binlog setting determines which transaction is rolled back.

A.It provides means to help avoid accidentally exposing the MySQL login details.

B.It is an alternative to storing the MySQL login details in a my.cnf file.

C.A .mylogin.cnf file can be edited using a text editor, such as vim or Notepad++.

D.A .mylogin.cnf file can store at most one login path.

E.mysql_config_editor is the only MySQL-provided utility that can print the values stored in
.mylogin.cnf.

F.It provides a FIPS-compliant keyring for storing MySQL login details.

A.mysql> CREATE USER ''@'' IDENTIFIED BY 'valid_password' WITH PROXY
'employee'@'localhost';
mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';

B.mysql> GRANT PROXY ON 'employee'@'localhost' TO 'robert'@'localhost';
mysql> CREATE USER 'robert'@'localhost' IDENTIFIED BY 'secret_password';

C.mysql>CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets';
mysql> CREATE_USER ''@'' IDENTIFIED WITH authentication_pam ACCOUNT LOCK;

D.mysql> CREATE USER 'employee'@'localhost' IDENTIFIED BY 'more_secrets'; mysql> GRANT PROXY ON 'employee'@'localhost' TO ''@'';

A.Use the --replicate-ignore-table option with the value equal to OLD_INVENTORY.OLD_INVENTORY and restart mysqld before creating the temporary table.

B.Stop SQL_THREAD on the slave until you have finished using the OLD_INVENTORY temporary table.

C.Change the binlog_format option to ROW and restart mysqld before you create the OLD_INVENTORY table.

D.Use the --replicate-do-db, --replicate-do-table, or --replicate-wild-do-table option with the value equal to OLD_INVENTORY.

E.Set binlog_format=MIXED with the --replicate-ignore-temp-table option.