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

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

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

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

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

A.No indexed columns are used to select rows from the Country table. The world.City.CountryCode column is used to select rows in the City table.

B.world.City.CountryCode is used as the primary key for the Country table.

C.world.City.CountryCode is used to sort the rows in the City table.

D.No indexed columns are used to select rows from the City table. The world.City.CountryCode column is used to select rows in the Country table.

A.mysql> SET GLOBAL sort_buffer_size=256000;

B.mysql> SET SESSION sort_buffer_size=256000;

C.mysql> CONF T; do global sort_buffer_size=256000;

D.mysql> system sort_buffer_size=256000;

E.mysql> SET VARIABLE sort_buffer_size=256000;

A.There are three indexes on the table.

B.There is a redundant index on the emp_no column.

C.The values on the emp_no column must be unique.

D.There is a redundant index on the dept_no column.

E.The selectivity of the dept_no column is the best of the indexed columns.

F.The secondary indexes are optimized for unique key look-ups.

A.port

B.character_set_system

C.innodb_buffer_pool_size

D.max_user_connections

E.join_buffer_size

F.innodb_log_file_size

G.max_connections