MySQL 8.0 Database Administrator — Question 7

Your MySQL server is running on the Microsoft Windows platform.
Which three local connection protocols are available to you? (Choose three.)

Answer options

• A. named pipes
• B. shared memory
• C. SOCKET
• D. X Protocol
• E. UDP
• F. TCP/IP

Correct answer: A, B, F

Explanation

The correct options are named pipes, shared memory, and TCP/IP, as these are the protocols supported for local connections on Windows. SOCKET is not a local connection protocol in this context, while X Protocol is used for different purposes, and UDP is not typically utilized for MySQL local connections.