A.mysqlbinlog --rewrite-db=’mydb1->mydb2’ | mysql

B.mysqlbinlog --rewrite-db=’mydb1’ --rewrite-db=’mydb2’ | mysql

C.mysqlbinlog --datebase=mydb1 --database=mydb2 | mysql

D.mysqlbinlog --read-from-remote-server --raw | sed ‘s/mydb1/mydb2/g’ | mysql

A.The mysqlcheck command can be renamed mysqlrepair so that it repairs tables by default.

B.The mysqlcheck --optimize --all-databases command reclaims free space from table files.

C.The mysqlcheck --repair --all-databases command can repair an InnoDB corrupted table.

D.The mysqlcheck --check --all-databases command takes table write locks while performing a series of checks.

E.The mysqlcheck --analyze --all-databases command performs a series of checks to spot eventual table corruptions.

A.Connections driven by MySQL Router are not affected by the command.

B.The mysql_innodb_cluster_metadata schema is dropped from the instance where the connection was established.

C.The command drops the mysql_innodb_cluster_metadata schema and re-creates it.

D.The mysql_innodb_cluster_metadata schema is dropped from all reachable members of the cluster.

E.Group Replication will be dissolved and all metadata purged.

F.Group Replication is still operational, but InnoDB Cluster must be reimported under MySQL Shell.

A.*.ibd files

B.ib_logfile* files

C.*.sdi files

D.*.CSM files

E.ibbackup files

A.UPDATE world.country SET Name=CONCAT('New ',Name);

B.UPDATE world.country SET Name='first' ORDER BY Name LIMIT

C.UPDATE world.country SET Name='all';

D.UPDATE world.country SET Name='new' WHERE Name='old';

E.UPDATE world.country SET Name='one' LIMIT 1;