A simple master-to-slave replication is currently being used. The following information is extracted from the SHOW SLAVE STATUS output:
Last_SQL_Error: Error 'Duplicate entry '8' for key 'PRIMARY' ' on query.
Default database: 'mydb'. Query: 'insert into mytable VALUES ('8' , 'George') ' Skip_Counter: 0 Retrieved _Gtid_Set: 38f32e23480a7-32a1-c323f78067fd37821: 1-8 Auto _Position: 1
You execute a "SHOW CREATE TABLE mytable" on the slave: CREATE TABLE 'mytable' ( 'ID' int(11) NOT NULL
DEFAULT '0', 'name' char(10) DEFAULT NULL, PRIMARY KEY ('ID') )
The table mytable on the slave contains the following:

You have issued a STOP SLAVE command. One or more statements are required before you can issue a START SLAVE command to resolve the duplicate key error. Which statement should be used（）

多项选择题Which two are true regarding MySQL binary and text backups?（）

A.Binary backups are usually faster than text backups
B.Binary backups are usually slower than text backups
C.Text backups are human-readable while binary backups are not
D.Binary backups are not portable across different operating systems

单项选择题While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）

A.Activating the MySQL Enterprise thread pool plugin
B.Relocating your data and log files to separate storage devices
C.Disconnecting idle localhost client sessions
D.Implementing storage engine data compression options

多项选择题Which three data components are needed for point-in-time recovery?（）

A.The error log
B.The backup log
C.The general query log
D.Binary logs
E.The data backup
F.Configuration files

单项选择题You need to dump the data from the master server and import it into a new slave server. Which mysqldump option can be used when dumping data from the master server in order to include the master servers binary log information?（）

A.Include-master-info
B.Master-binlog
C.Include-log-file
D.Master-data

单项选择题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）

A.— quick
B.— skip-buffer
C.— single-transaction
D.— tab