多项选择题

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

A.File system snapshots
B.Mysqldumpslow
C.Mysqlhotcopy
D.Mysqldump with – binary-data option
E.Mysql Enterprise Backup

点击查看答案

上一题目录下一题

相关考题

多项选择题

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…