Please pick one answer for each question Please pick one ans
Please pick one answer for each question.
| Please pick one answer for each question. 
 Captures information about queries that take longer than a pre-defined time interval to complete. Assists in restoration and replication, as well as providing a record of all changes that were made to the database. Keeps a record of major events, such as a server start/stop. | 
Solution
Question 1 - the server query log option 1 - Tracks information about all queries that have been submitted on the MySQL server.
Question 3 - option 3 - Captures information about queries that take longer than a pre-defined time interval to complete.
Question 4 - option 4 - available views is not considered by query optimizer because it is not real table
Question 5 - option 4- The query optimizer guarantees that the optimally performing execution path is automatically selected

