A.The join buffer is global and can be changed only by restarting the server.

B.The value should be increased if the client performs several SELECToperations.

C.The join buffer is used to process sorts when complex joins are being performed.

D.The value should be increased from the default if the query joins large rows without using an index.

E.The join buffer is set per connection.

A.binlog_format=STATEMENT

B.log-bin

C.apply-log

D.bonlog_format=ROW

E.gtid_enable

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

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

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

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

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

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

A.It caches index blocks for InnoDB tables only.

B.It caches index blocks for all storage engine tables.

C.It is set on a per-connection basis.

D.It is a global buffer.

E.It caches index blocks for MyISAM tables only.

A.It can be used to export TEMPORARYtables.

B.Table only exports when the table has its own tablespace.

C.The InnoDB Storage engine must be used for the table being exported.

D.It is the safest way to extract tables from the shared tablespace.

E.Partitioned tables are not supported.