Which statement is true about FLUSH LOGS command?
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.
Explanation:
Reference: http://dev.mysql.com/doc/refman/5.5/en/flush.html
B, RM 5.6 page 1688
B
With no log_type option, FLUSH LOGS closes and reopens all log files. If binary logging is enabled, the sequence number of the binary log file is incremented by one relative to the previous file.
B
B,
thank guy’s for your contribution i just passed the exam today with 77%
Are the real questions from this website?
for B, I’m having concern with the word “all”.. strictly it should be “any”..
https://dev.mysql.com/doc/refman/5.7/en/flush.html#flush-logs
leaning towards D.