A.query cache

B.thread cache

C.read buffer

D.internal temporary table

E.sort buffer

F.InnoDB buffer pool instance

A.There are 108 queries still being executed.

B.There is network congestion between client and server.

C.A table lock is causing delays.

D.No index has been defined on the filtered column.

E.A full table scan is being used.

A.the mysql_upgrade script

B.the mysql client with the --ignore-password-hashing option

C.the mysql_secure_installation script to update server security settings

D.the mysql client with the --enable-cleartext-plugin option

E.the install plugin command for the mysql_cleartext_password plugin

A.Increase the value of the innodb_read_io_threads option.

B.Deactivate the query cache.

C.Set the value of innodb_adaptive_hash_index to zero.

D.Increase the size of the InnoDB buffer pool.

E.Change the table to use HASH indexes instead of BTREE indexes.

F.Increase the value of the innodb_lock_wait_timeout option.

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

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

C.There are three indexes on the table.

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

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

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