多项选择题
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
