A.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';

B.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';

C.GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

D.GRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

A.The user is authenticated as the anonymous proxy user ''@'%'.

B.The user failed to define a username and the connecting username defaulted to ''@'%'.

C.The user is logged in with --user=accounting as an option.

D.The user is authorized as the accounting@localhost user.

E.The user is authorized as the rsmith@localhost user.

A.There is no need for InnoDB tables to perform its own recovery when restoring from the snapshot backup.

B.The frozen file system can be cloned to another virtual machine immediately into active service.

C.A separate physical copy must be made before releasing the snapshot backup.

D.Snapshot-based backups greatly reduce time during which the database and applications are unavailable.

E.Snapshot backups can be used only in virtual machines.

A.The master is most probably too busy to transmit data and the slave needs to wait for more data.

B.One or more large tables do not have primary keys.

C.This value shows only I/O latency and is not indicative of the size of the transaction queue.

D.The master is producing a large volume of events in parallel but the slave is processing them serially.

E.The parallel slave threads are experiencing lock contention.

A.If OPTIMIZE LOCAL TABLE t; is invoked from another session, it executes normally and returns the status.

B.If OPTIMIZE TABLE; is invoked, it will create a table lock on t and force a transaction rollback.

C.If ANALYZE TABLE; is invoked from the same session, it hangs until the transaction is committed or rolled back.

D.mysqlcheck --analyze --all-databases will execute normally on all tables and return a report.