A.They contain events that describe only administrative commands run on the master.

B.They contain events that describe all queries run on the master.

C.They are pushed from the master to the slave.

D.They contain events that describe database changes on the master.

E.They are pulled from the master to the slave.

A.dba.configureInstance()

B.cluster.setPrimaryInstance()

C.dba.configureLocalInstance()

D.cluster.forceQuorumUsingPartitionOf()

E.cluster.addInstance()

F.dba.createCluster()

G.dba.checkInstanceConfiguration()

A.DESCRIBE manufacturing.parts;

B.SELECT * FROM information_schema.statistics WHERE table_schema=’manufacturing’
AND TABLE_NAME=’parts’;

C.SHOW INDEXES FROM manufacturing.parts;

D.SELECT * FROM information_schema.COLUMN_STATISTICS;

E.EXPLAIN SELECT INDEXES FROM manufacturing.parts;

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

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

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 and kill -9 are effectively the same forced shutdown that risk committed transactions not written to disk.

A.installing and configuring the Connection Control plugin

B.avoiding concatenation of SQL statements and user-supplied values in an application

C.using stored procedures for any database access

D.using PREPARED STATEMENTS