多选题You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files?（）AUse the command PURGE BINARY LOGS and specify a binary log f

A.It deletes all binary log files, except ‘mysql-in.010‘

B.It deletes all binary log files up to and including ‘mysql-bin.010‘

C.It deletes all binary log files before ‘mysql-bin.010‘

D.It deletes all binary log files after ‘mysql-bin.010‘

A.Always stop the server prior to the backup

B.Stop the server or lock the tables prior to the backup

C.Stop the server or lock the databases prior to the backup

D.Make a copy of the .frm, .myd, and the .myi files

E.Make a copy of the binary log and tablespace files

You issued the following commands to configure setting in RMAN;Then you issued the following command to take the backup:RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which statement is true about the execution of the above command?（）

A. The backup will terminate because the FORMAT clause was not configured for the channel

B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

A.Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files

B.Execute the PURGE BINARY LOGE NOT USED command

C.Remove all of the binary log files that have a modification date earlier than today

D.Edit the .index file to remove the files you want to delete

E.Ensure that none of the attached slaves are using any of the binary logs you want to delete

A general purpose MySQL instance is configured with the following options:—log-slow-queries—long-query-time=,0001—log-slow-admin-queries—general-log—log-bin—binlog-format=STATEMENT—innodb-flush-log-at-trx-commit=1Which three statements are true（）。

A.The General Query Log records more data than the Binary Log

B.The binary Log records more data than the General Query Log

C.The Slow Query Log records more data than the General Query Log

D.The General Query Log records more data than the Slow Query Log

E.The Slow Query Log records more data than the Binary Log

F.The Binary Log records more data than the Slow Query Log

A.It requires the RELOAD, FILE, and DROP privileges

B.It closes and reopens all log files

C.It closes and sends binary log files to slave servers

D.It flushes dirty pages in the buffer pool to the REDO logs

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 server‘s binary log information?（）

A.Include-master-info

B.Master-binlog

C.Include-log-file

D.Master-data