MySQL5.7 OCP每日一题--Day16

Question: 22

Which three are key advantages of standard MySQL replication? 
A. supports native automatic failover 
B. enables automatic resync of databases when discrepancies are detected 
C. provides arbitrary geographic redundancy with minimal overhead to master 
D. synchronously guarantees identical slave copy 
E. is easy to configure and has low performance overhead 
F. can easily add slaves for read scaling 
复制

答案：CEF
解析：标准的MySQL复制不支持故障转移，不支持自动差异检测。

Question: 23

Which MySQL utility program should you use to process and sort the Slow Query Log based on query time or average query time? 
A. mysqldumpslow 
B. mysqldump 
C. mysqlaccess 
D. mysqlshow 
E. mysqlslow 
复制

答案： A
解析：无