A user executes the statement; PURGE BINARY LOGS TO `mysql-bin.010'; What is the result?

Question

Options

• AIt deletes all binary log files, except `mysql-in.010'.
• BIt deletes all binary log files up to and including `mysql-bin.010'.
• CIt deletes all binary log files before `mysql-bin.010'.
• DIt deletes all binary log files after `mysql-bin.010'.

• A
  3% (1)
• B
  14% (5)
• C
  77% (27)
• D
  6% (2)

Explanation

The PURGE BINARY LOGS statement deletes all the binary log files listed in the log index file prior to the specified log file name.

No community discussion yet for this question.