MariaDB quiz

Test your MariaDB knowledge with a free interactive quiz — 40 questions with answers and explanations. No signup needed to play.

What does `GRANT SELECT ON mydb.* TO 'app_user'@'%';` do?

1. What does `GRANT SELECT ON mydb.* TO 'app_user'@'%';` do?
2. What client tool connects interactively to a MariaDB server from the command line?
3. What does `mysqldump` produce?
4. What is InnoDB in MariaDB?
5. What is a primary key in a MariaDB table?
6. What is the default port MariaDB listens on?
7. Which command shows the query execution plan for a SELECT statement?
8. What does `SHOW ENGINES;` do in MariaDB?
9. Which JOIN type returns only rows that have matching values in both tables?
10. What is the difference between `CHAR` and `VARCHAR` column types?
11. What does `AUTO_INCREMENT` do on a column?
12. What is the purpose of an index in MariaDB?

More quizzes