MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.

1. Which default port does MySQL use for network connections?
   a. 8080
   b. 3306
   c. 1433
   d. 1521
   Answer: b. 3306dbvis
2. What configuration parameter in MySQL specifies the IP address to which the server listens for incoming connections?
   a. listen-port
   b. bind-address
   c. server-host
   d. socket-address
   Answer: b. bind-addressserversforhackers
3. What is the most secure networking mode for deploying a MySQL server in Azure?
   a. Public endpoint
   b. Private endpoint
   c. DMZ mode
   d. Cluster mode
   Answer: b. Private endpointlearn.microsoft
4. MySQL client-server communication uses which protocol for remote connections by default?
   a. HTTP
   b. UDP
   c. TCP/IP
   d. FTP
   Answer: c. TCP/IPsealos
5. Which port should be opened on a firewall to allow remote MySQL access?
   a. 80
   b. 443
   c. 3306
   d. 27017
   Answer: c. 3306vexxhost
6. What is the main security risk of binding MySQL to 0.0.0.0?
   a. Database corruption
   b. Performance overhead
   c. Exposure to all networks
   d. Slow query response
   Answer: c. Exposure to all networksdigitalocean+1
7. To limit which hosts can connect to MySQL, what field is specified for each user account?
   a. Group
   b. Role
   c. Host
   d. Privilege
   Answer: c. Hostserversforhackers
8. MySQL supports encrypted network connections using which protocol?
   a. TLS
   b. SSH
   c. GRE
   d. SFTP
   Answer: a. TLSmysql+1
9. Which command sets up MySQL to listen on a specific TCP/IP port?
   a. SET PORT=3306;
   b. bind-port=3306
   c. port=3306
   d. netport=3306
   Answer: c. port=3306stackoverflow+1
10. What is a recommended minimum bit length for RSA keys in MySQL TLS certificates?
    a. 512
    b. 1024
    c. 2048
    d. 4096
    Answer: c. 2048mysql
11. What is the main advantage of using a private endpoint for MySQL in cloud deployments?
    a. Faster backups
    b. Private and secure communication
    c. Lower costs
    d. Increased replication speed
    Answer: b. Private and secure communicationlearn.microsoft
12. Which user privilege is required on the source MySQL server for replication?
    a. SELECT
    b. REPLICATION SLAVE
    c. CREATE USER
    d. EXECUTE
    Answer: b. REPLICATION SLAVEred-gate+1
13. What is the default MySQL configuration if bind-address is not defined?
    a. Listens on no networks
    b. Listens only on localhost
    c. Listens on all networks
    d. Listens only on public IP
    Answer: c. Listens on all networksserversforhackers
14. Which MySQL connection type is used for fastest local access on Unix systems?
    a. TCP/IP
    b. Named pipe
    c. Unix socket
    d. HTTP
    Answer: c. Unix socketsealos
15. To restrict users from establishing more than a specific number of connections, which variable is used?
    a. max_connection_limit
    b. max_user_connections
    c. user_connection_max
    d. host_connection_max
    Answer: b. max_user_connectionspercona+1
16. What network concept is essential for MySQL replication between source and replica servers?
    a. Low latency
    b. Unique MAC address
    c. Network connectivity
    d. VLAN tagging
    Answer: c. Network connectivitypercona+1
17. Which MySQL feature helps secure client-server communication over public networks?
    a. Caching
    b. Query optimization
    c. TLS encryption
    d. Replication
    Answer: c. TLS encryptionmysql+1
18. Which MySQL command sets a user’s max concurrent connections?
    a. ALTER USER WITH MAX_CONNECTIONS
    b. ALTER USER WITH MAX_USER_CONNECTIONS
    c. ALTER USER WITH USER_LIMIT
    d. ALTER USER SET CONNECTIONS
    Answer: b. ALTER USER WITH MAX_USER_CONNECTIONSmysql+1
19. Which configuration change is required to enable MySQL remote access?
    a. Enable nosocket
    b. Set bind-address appropriately
    c. Set server-id to 0
    d. Use user WITHOUT host
    Answer: b. Set bind-address appropriatelydigitalocean+1
20. Which MySQL storage engine supports networked connections in distributed architectures?
    a. InnoDB
    b. Memory
    c. Federated
    d. Archive
    Answer: c. Federatedsealos
21. What is the principle of least privilege in MySQL networking?
    a. Restrict user access to only what is required
    b. Grant full admin rights to all users
    c. Disable encryption
    d. Use DSM for syncing
    Answer: a. Restrict user access to only what is required200oksolutions
22. To secure remote MySQL connections, what networking layer should a firewall restrict?
    a. Data link
    b. Physical
    c. Transport
    d. Application
    Answer: c. Transportmoldstud+1
23. When setting up MySQL replication, which server must have a unique server ID?
    a. Only source
    b. Only replica
    c. Both source and replica
    d. No server
    Answer: c. Both source and replicared-gate+1
24. Which command enables global MySQL firewall?
    a. SET GLOBAL firewall ON;
    b. SET GLOBAL firewall_enabled=’ON’;
    c. ENABLE FIREWALL;
    d. ACTIVATE FIREWALL;
    Answer: b. SET GLOBAL firewall_enabled=’ON’;chat2db
25. What type of network does a MySQL private endpoint use in cloud networking?
    a. DMZ
    b. Virtual network
    c. LAN
    d. WAN
    Answer: b. Virtual networklearn.microsoft
26. What is the most important reason for restricting MySQL’s listening address to localhost?
    a. Improve performance
    b. Reduce RAM usage
    c. Minimize attack surface
    d. Enable HTTP access
    Answer: c. Minimize attack surfacedigitalocean+1
27. How does MySQL identify client sessions using encrypted connections?
    a. User credentials only
    b. Ssl_version and Ssl_cipher variables
    c. MAC address
    d. Port number
    Answer: b. Ssl_version and Ssl_cipher variablesmysql
28. Which MySQL user attribute determines if a user connects locally or remotely?
    a. Port
    b. Host
    c. Username
    d. Connection string
    Answer: b. Hostserversforhackers+1
29. When configuring a MySQL firewall, which step is essential before deploying rules?
    a. Disabling logging
    b. Testing the configuration
    c. Increasing storage
    d. Restarting server
    Answer: b. Testing the configurationmoldstud+1
30. What is the MySQL variable for setting overall concurrent connection limits?
    a. concurrent_limit
    b. user_connections_limit
    c. max_connections
    d. max_session
    Answer: c. max_connectionsmysql
31. In MySQL, what does disabling public network access achieve?
    a. Increased host privilege
    b. Database isolation from the internet
    c. Higher bandwidth usage
    d. Increased replication speed
    Answer: b. Database isolation from the internetlearn.microsoft
32. Which configuration enables MySQL to listen on both IPv4 and IPv6 loopback interfaces?
    a. bind-address=localhost
    b. bind-address=0.0.0.0
    c. bind-address=127.0.0.1,::1
    d. bind-address=192.168.1.1
    Answer: c. bind-address=127.0.0.1,::1serversforhackers
33. What feature improves MySQL connection efficiency in network environments?
    a. Query logging
    b. Connection pooling
    c. Engine switching
    d. Binary logging
    Answer: b. Connection poolingsealos
34. To restrict MySQL connections from only a specific subnet, which firewall syntax would you use?
    a. allow=192.168.1.0/24
    b. allow=192.168.2.0/16
    c. allow=any
    d. allow=10.0.0.0/8
    Answer: a. allow=192.168.1.0/24moldstud
35. What encryption protocol versions does MySQL 8.4 support for secure connections?
    a. SSLv2 and SSLv3
    b. TLSv1.2 and TLSv1.3
    c. SSHv2 and SSHv3
    d. IPsec v2
    Answer: b. TLSv1.2 and TLSv1.3mysql
36. What helps achieve optimal security when deploying MySQL over a network?
    a. Disable firewalls
    b. Leave port 3306 open to all
    c. Restrict access to trusted IPs
    d. Use default credentials
    Answer: c. Restrict access to trusted IPsdigitalocean+1
37. Which command shows current connection status in MySQL?
    a. SHOW CONNECT;
    b. SHOW CONNECTIONS;
    c. SHOW PROCESSLIST;
    d. SHOW STATUS;
    Answer: c. SHOW PROCESSLIST;mysql
38. What is a recommended action after changing the MySQL port in the configuration file?
    a. Clear the logs
    b. Restart the MySQL server
    c. Change root password
    d. Update firewall rules
    Answer: b. Restart the MySQL serverstackoverflow+1
39. What role does the GRANT statement play in MySQL networking security?
    a. Sets port
    b. Restricts privileges for users
    c. Lists current connections
    d. Monitors replication
    Answer: b. Restricts privileges for users200oksolutions
40. In MySQL networking, what does ‘SELECT User, Host from mysql.user;’ display?
    a. Active sessions
    b. User accounts and allowed hosts
    c. Port mapping
    d. Table size
    Answer: b. User accounts and allowed hostsserversforhackers
41. What is a key requirement for initializing a MySQL replica server?
    a. Setting server-id
    b. Disabling replication
    c. Removing binary logs
    d. Defaulting user privileges
    Answer: a. Setting server-idpercona+1
42. What MySQL command restricts a user to a maximum queries per hour?
    a. ALTER USER … WITH MAX_QUERIES_PER_HOUR
    b. SET QUERIES_HOURLY_LIMIT
    c. ENABLE QUERIES_LIMIT
    d. LIMIT_QUERIES 100
    Answer: a. ALTER USER … WITH MAX_QUERIES_PER_HOURmysql
43. What network component is essential to audit for preventing unauthorized MySQL access?
    a. DNS server
    b. Firewall rules
    c. Web proxy
    d. Mail server
    Answer: b. Firewall rules200oksolutions+1
44. Which protocol does MySQL recommend avoiding due to weak encryption for network connections?
    a. SSL
    b. TLS
    c. SSH
    d. HTTP
    Answer: a. SSLmysql
45. What is the default user for MySQL administration on most Linux installations?
    a. root
    b. admin
    c. sysdba
    d. superuser
    Answer: a. root200oksolutions+1
46. Why should MySQL’s default port be changed in production environments?
    a. Improve replication
    b. Reduce disk space
    c. Minimize automated attack risks
    d. Make backups faster
    Answer: c. Minimize automated attack risksdbvis+1
47. What does enabling MySQL’s firewall feature protect against?
    a. Slow queries
    b. Malicious SQL statements
    c. High memory usage
    d. Incomplete backups
    Answer: b. Malicious SQL statementschat2db+1
48. What MySQL network best practice improves login security?
    a. Use HTTP logins
    b. Passwordless authentication
    c. Strong password policies
    d. Anonymous users
    Answer: c. Strong password policies200oksolutions
49. In MySQL, what does the setting ‘socket = /var/run/mysqld/mysqld.sock’ do?
    a. Configures replication
    b. Specifies Unix socket for local connections
    c. Defines remote endpoint
    d. Sets firewall on
    Answer: b. Specifies Unix socket for local connectionsserversforhackers
50. Which MySQL user should not be used for day-to-day network tasks for security reasons?
    a. admin_user
    b. backup_user
    c. root
    d. reporting_user
    Answer: c. root200oksolutions

1. https://www.dbvis.com/thetable/mysql-port-numbers/
2. https://serversforhackers.com/c/mysql-network-security
3. https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking
4. https://sealos.io/blog/what-is-mysql
5. https://vexxhost.com/resources/tutorials/how-to-allow-remote-access-to-mysql/
6. https://www.digitalocean.com/community/tutorials/how-to-allow-remote-access-to-mysql
7. https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
8. https://dev.mysql.com/doc/refman/8.1/en/encrypted-connection-protocols-ciphers.html
9. https://stackoverflow.com/questions/29866204/how-to-change-the-default-port-of-mysql-from-3306-to-3360
10. https://www.red-gate.com/simple-talk/blogs/beginners-guide-to-mysql-replication-part-1/
11. https://www.percona.com/blog/overview-of-different-mysql-replication-solutions/
12. https://www.percona.com/blog/setting-up-resource-limits-on-users-in-mysql/
13. https://dev.mysql.com/doc/refman/8.1/en/user-resources.html
14. https://200oksolutions.com/blog/database-security-best-practices-in-mysql/
15. https://moldstud.com/articles/p-enhance-your-database-security-using-mysql-firewalls-for-optimal-protection
16. https://chat2db.ai/resources/blog/database-security-with-mysql-firewall
17. https://www.geeksforgeeks.org/mysql/architecture-of-mysql/
18. https://www.tessell.com/blogs/mysql-concepts-benefits-and-use-cases
19. https://dev.mysql.com/doc/refman/8.3/en/what-is-mysql.html
20. https://www.w3schools.com/mysql/mysql_intro.asp