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

B.DROP USER `'@'localhost';

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

D.ALTER USER bob PASSWORD = `secret_password';

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

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

A.All data in p1 and p3 partitions is removed, but the table definition remains unchanged.

B.It results in a syntax error because you cannot specify more than one partition in the same statement.

C.Only the first partition (p1) will be dropped because only one partition can be dropped at any time.

D.All data in p1 and p3 partitions is removed and the table definition is changed.

A.binlog_format=STATEMENT

B.log-bin

C.apply-log

D.bonlog_format=ROW

E.gtid_enable

A.Create a master-master pair for each service.

B.Use RAID 10 storage for datA.

C.Implement a failover strategy to another geographic location.

D.Use on-site network-attached storage to separate service from datA.

E.Have a second data centre in a different region or country.

F.Keep software updated to the latest version.

A.Binary

B.Logical

C.Hot

D.Incremental