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.

(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.

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

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 qu

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site