Which isolation level in MySQL prevents dirty reads but allows non-repeatable reads?
What is the purpose of the `EXPLAIN` statement in MySQL?
Which of the following is NOT a valid data type in MySQL?
What is the primary use case for the `GROUP BY` clause in a SQL query?
Which storage engine in MySQL is known for its transaction support and row-level locking?
What is the purpose of a foreign key constraint?
Which command is used to create a new user account in MySQL?
What is the function of the `AUTO_INCREMENT` attribute in MySQL?
Which SQL command is used to modify the structure of an existing table?
What is the default port number used by MySQL server?