Please pick one answer for each question. Please pick one answer for each questi

Question

Please pick one answer for each question.

Please pick one answer for each question.

(TCO 1) The General Query Log: (Points : 10)        Tracks information about all queries that have been submitted on the MySQL server.
       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.

Explanation / Answer

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

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---