What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）

多项选择题You want to shutdown a running Mysql Server cleanly. Which three commands that are valid on either Windows or Linux will achieve this?（）

A.Shell＞ mysqladmin –u root –p shutdown
B.Shell＞ nmc mysql shutdown
C.Mysql＞ STOP PROCESS mysqld
D.Shell＞ /etc/init.d/mysql stop
E.Shell＞ service mysql safe_exit
F.Shell＞ pkill –u mysql mysqld_safe
G.Shell＞ net stop mysql

多项选择题When backing up a replication slave, which three should also be backed up in addition to data?（）

A.The master.info and relay.info files
B.The relay log files
C.The relay index file
D.Mysql.slave_master_info table
E.Mysql.slave_relay_log_info table
F.Mysql.slave_worker_info table

单项选择题User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）

A.UPDATE pets…
B.SELECT….FROM pets
C.INSERT INTO pets…
D.ALTER TABLE pets…

单项选择题You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）

A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE

多项选择题Which two statements are true regarding partitioning in Mysql?（）

A.Tables with BLOB and TEXT columns cannot be partitioned
B.Partitioning allows easier management of smaller data sets for certain queries
C.Partitioning allows different columns to be stored in separate files
D.The partitioning expression is an integer or function that returns an integer value or NULL value
E.Partitioning is only available for those storage engines that implements it natively