MariaDB quiz

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

What is a foreign key constraint used for?

1. What is a foreign key constraint used for?
2. What does `mysqldump` produce?
3. What does `SHOW ENGINES;` do in MariaDB?
4. Which clause filters rows returned by a `SELECT` before grouping?
5. What client tool connects interactively to a MariaDB server from the command line?
6. What is a primary key in a MariaDB table?
7. What is a transaction in MariaDB (InnoDB)?
8. What does `AUTO_INCREMENT` do on a column?
9. What is the difference between `CHAR` and `VARCHAR` column types?
10. What does `GRANT SELECT ON mydb.* TO 'app_user'@'%';` do?
11. What is the default port MariaDB listens on?
12. Which command shows the query execution plan for a SELECT statement?

More quizzes