A.The slave will need an estimated 360 seconds to update the remaining contents from the relay log.

B.The slave was configured for delayed replication with a delay of six minutes.

C.The network latency between the master and the slave is 360 milliseconds.

D.The master has performed a large transaction, which will take 360 seconds to complete on the slave.

A.It caches index blocks for MyISAM tables only.

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

C.It is a global buffer.

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

E.It caches index blocks for InnoDB tables only.

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

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

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

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

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

F.There are three indexes on the table.

A.mysqlfailover

B.mysqlrplsync

C.mysqlserverclone

D.mysqldbcopy

A.Date should be a TIMESTAMP field for better performance.

B.The engine type is not appropriate to the application use.

C.The User field is too long for most names.

D.No indexes are defined.

E.Using default values for DATETIME causes table scans.