SQL final quiz

  • Admin
  • 1 min read

Ten mixed questions covering the whole SQL track, from SELECT to transactions.

SQL

SQL final quiz

10 questions, instant feedback

Question 1 of 10 Which clause order is valid in a SELECT statement?
Question 2 of 10 A table has 100 rows and 12 have a NULL email. What does COUNT(email) return?
Question 3 of 10 Which query lists categories with more than five products?
Question 4 of 10 Which join finds customers who have never ordered?
Question 5 of 10 What does ROLLBACK do?
Question 6 of 10 Which column type best stores a boolean flag in SQLite?
Question 7 of 10 What is the main risk of SELECT * in application code?
Question 8 of 10 Why can LIMIT without ORDER BY return different rows each run?
Question 9 of 10 Which change adds an index on orders.customer_id?
Question 10 of 10 A query joining three tables returns duplicated rows. What is the usual cause?

Your answers stay in this browser. Nothing is sent to a server.