MySQL Server Configuration & Variables Quiz

1. What is the purpose of the sort_buffer_size variable?

Allocate memory for sorting operations during queries

Control temporary table storage

Limit index cache size

Define binary log buffer capacity

Submit

3. What is the purpose of the key_buffer_size variable?

Cache MyISAM index blocks in memory

Buffer InnoDB redo logs

Store query results

Control connection buffer

4. True or False: The skip-external-locking option improves performance on single-server environments.

True

False

5. Which configuration controls the number of table cache entries?

Table_cache

Table_open_cache

Open_files_limit

Cache_size

Submit

7. What does the read_only variable do when set to ON?

Prevents all write operations for non-admin users

Disables index creation

Stops binary logging

Restricts SELECT queries

8. True or False: Setting innodb_autoinc_lock_mode=2 allows concurrent inserts with AUTO_INCREMENT.

True

False

9. Which variable specifies the timeout for idle client connections?

Idle_timeout

Wait_timeout

Connection_timeout

Session_timeout

Submit

11. Which system variable controls the maximum number of simultaneous client connections to a MySQL server?

Max_connections

Max_clients

Connection_limit

Max_users

12. True or False: The query_cache is recommended for all workloads in modern MySQL versions.

True

False

13. Which system variable defines the SQL mode for strict data validation?

Validation_mode

Sql_mode

Strict_mode

Data_mode

Submit

15. What does the binlog_format variable control?

Binary log file size limit

Format of binary log entries (STATEMENT, ROW, or MIXED)

Encryption method for binary logs

Backup frequency interval

16. True or False: The variable innodb_flush_log_at_trx_commit=0 ensures maximum durability for transactions.

True

False

17. Which configuration parameter controls whether slow queries are logged?

Log_slow_queries

Slow_query_log

Enable_slow_log

Query_log_slow

Submit

19. Which variable determines the storage engine used by default for new tables?

Default_engine

Default_storage_engine

Storage_engine

Table_engine

20. What is the primary purpose of the innodb_buffer_pool_size variable?

Store query cache results

Cache InnoDB table and index data in memory

Limit temporary table size

Control binary log buffer capacity

MySQL DBA Server Configuration and System Variables Quiz

1. What is the purpose of the sort_buffer_size variable?

2.

What first name or nickname would you like us to use?

2. The ______ variable specifies the server's unique identifier in replication topology.

3. What is the purpose of the key_buffer_size variable?

4. True or False: The skip-external-locking option improves performance on single-server environments.

5. Which configuration controls the number of table cache entries?

6. The ______ variable determines the maximum size of internal temporary tables before disk storage is used.

7. What does the read_only variable do when set to ON?

8. True or False: Setting innodb_autoinc_lock_mode=2 allows concurrent inserts with AUTO_INCREMENT.

9. Which variable specifies the timeout for idle client connections?

10. The ______ variable controls the number of InnoDB background I/O threads.

11. Which system variable controls the maximum number of simultaneous client connections to a MySQL server?

12. True or False: The query_cache is recommended for all workloads in modern MySQL versions.

13. Which system variable defines the SQL mode for strict data validation?

14. The ______ variable sets the number of threads created to handle client connections.

15. What does the binlog_format variable control?

16. True or False: The variable innodb_flush_log_at_trx_commit=0 ensures maximum durability for transactions.

17. Which configuration parameter controls whether slow queries are logged?

18. The ______ variable specifies the maximum packet size allowed in client-server communication.

19. Which variable determines the storage engine used by default for new tables?

20. What is the primary purpose of the innodb_buffer_pool_size variable?