Oracle Database MySQL 5.6 Developer — Question 28

Using the MYSQL command –line client you have received the error "Lost connection to MYSQL server query"
Which three are possible causes of the error?

Answer options

• A. The MYSQL server stopped working during query execution.
• B. The network connection was interrupted during query execution.
• C. The connection that issued the query was killed.
• D. The client connection stayed idle for longer than interactive –timeout seconds and was closed.
• E. The client sent an erroneous query to the server causing the connection to be closed.
• F. The server interrupted client connection after max-connect-errors was achieved.

Correct answer: B, E, F

Explanation

The correct answers are B, E, and F. Option B is valid because a network interruption can lead to the loss of connection during query execution. Option E is correct since an erroneous query can cause the server to terminate the connection. Option F is also accurate as exceeding max-connect-errors leads to the server closing the connection. Options A, C, and D do not specifically relate to the 'Lost connection' error in the context provided.