MySQL Quiz
Test what you have learned in this MySQL tutorial. Choose an answer for each question and read the explanation.
Before You Start
The questions cover every lesson:
- Getting started and creating databases
- Data types and creating tables
- Insert, select, update and delete
- Functions, indexes, views and transactions
Question 1
Exercise
Which command lists all databases on the MySQL server?
Question 2
Exercise
Which character set should a new MySQL database use to store Urdu text and emoji?
Question 3
Exercise
Which type is best for a mobile number such as 0300-1234567?
Question 4
Exercise
Which function returns the id that AUTO_INCREMENT created for the last inserted row?
Question 5
Exercise
What does SELECT * FROM products ORDER BY id LIMIT 5 OFFSET 10; return?
Question 6
Exercise
Which function joins text values together in MySQL?
Question 7
Exercise
What is the main benefit of an index on a column?
Question 8
Exercise
Which statement is true about a MySQL view?
Question 9
Exercise
Which command makes all changes in the current transaction permanent?
What Next?
Well done on finishing the MySQL tutorial. Use MySQL from a real app with PHP or Node.js, or compare it with PostgreSQL.