先試後買

A. It monitors and schedules the rotation/deletion of the binary logs.

B. It reads the relay log and executes the events contained in them.

C. It connects to the master and asks it to send updates recorded in its binary logs.

D. It acquires a lock on the binary log for reading each event to be sent to the slave.

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

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

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

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

A. It fails if any of the roles is specified in the mandatory_roles variable.

B. It fails if you do not have the ADMIN OPTION of the roles r_role1 and r_role2.

C. Existing connections can continue to use the roles' privileges until they reconnect.

D. You must revoke all privileges from r_role1 and r_role2 before dropping the roles.

E. You must revoke r_role1 and r_role2 from all users and other roles before dropping the roles.

F. It fails if at least one of the roles does not exist.

A. MyISAM

B. NDB

C. ARCHIVE

D. InnoDB

E. MEMORY

A. kill -15 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

B. kill -15 should be avoided. Use other methods such as mysqladmin shutdown or systemctl stop mysqld.

C. mysqld_safe prohibits commands that would harm the operation of the server. An error would be returned by the kill command.

D. kill -15 carries out a normal shutdown process, such as mysqladmin shutdown.

A. Binary logs contain only transactions originating from a single MySQL instance.

B. Replication can use only TCP/IP connections.

C. Each instance in a replication topology must have a unique server ID.

D. Each slave must have its own MySQL user for replication.

E. Binary logging must be enabled on the master in order to replicate to other instances.

F. Any instance can have multiple slaves, but it can have only one master.

G. A replication user must have the SELECT privilege for all tables that need to be replicated.

A. The copy-back process is used to overwrite a new backup over an existing backup.

B. The copy-back process makes inconsistent backups.

C. It restores files from the backup directory to their original MySQL server locations.

D. It restores files from the data directory to their original MySQL server locations.

A. MySQL server was not started due to a problem while executing process 2732.

B. MySQL server continued to start up even though another process existed.

C. systemd attempted to start mysqld, found another systemd mysqld process running, and shut it down.

D. systemd waited for 30 seconds before timing out and start up failed.

E. systemd found the mysqld service disabled and failed to start it.

A. The minimum value increases to 3000 and the maximum value increases to 4000.

B. An error is returned.

C. The minimum connection value is changed to 2000.

D. Only the minimum connection value is increased to 3000.

A. shell> cp /backup/customers.sdi /var/tmp

B. shell> cp /backup/customers.sdi /var/lib/mysql/shop/

C. mysql> IMPORT TABLE FROM /var/tmp/customers.sdi

D. mysql> IMPORT TABLE FROM /var/lib/mysql/shop/customers.sdi

E. mysql> SOURCE '/var/tmp/customers.sdi'

F. shell> cp /backup/customers.frm /var/lib/mysql/shop/

G. mysql> ALTER TABLE shop.customers DISCARD TABLESPACE

H. mysql> ALTER TABLE shop.customers IMPORT TABLESPACE