A.to prevent schema changes from propagating to the slave before they are validated

B.to allow a backup to be created under reduced load

C.to allow the remaining events to be processed on the slave while not receiving new events from the master

D.to allow for point-in-time recovery on the slave

E.to prevent any transaction experiencing a deadlock

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

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

C.It can be used to export TEMPORARY tables.

D.Partitioned tables are not supported.

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

A.There is network congestion between client and server.

B.There are 108 queries still being executed.

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

D.A full table scan is being used.

E.A table lock is causing delays.

A.The host on the command line is not defined in the login path.

B.There is no password defined in the login path.

C.The DNS is not configured correctly for slave1 host.

D.The mysqld instance has not been restarted after creating the login path.

E.The .mylogin.cnf file is not readable.

A.ALTER USER bob@'%' IDENTIFIED BY `secret_password';

B.DROP USER `'@'localhost';

C.REVOKE ALL PRIVILEGES FROM `'@'localhost';

D.ALTER USER `'@'localhost' PASSWORD = `secret_password';

E.ALTER USER bob PASSWORD = `secret_password';

F.ALTER USER `root'@'localhost' ACCOUNT LOCK;