Start learning →

‹ Databases

Databases quiz: 45 questions

45 questions from the 15 lessons of Database Management Systems. Each answer is explained, with a link back to the lesson it comes from, and your best score stays on this device.

Test yourself

45 questions from this course's lessons, in a random order. See what you remember, then go back to the lessons behind the questions you missed.

How many questions?

What the quiz covers

  1. Databases and tables (3 questions)
  2. Creating tables and adding rows (3 questions)
  3. Choosing rows and columns: SELECT and WHERE (3 questions)
  4. Sorting, limiting and DISTINCT (3 questions)
  5. Changing and deleting rows (3 questions)
  6. Counting and totals: GROUP BY and HAVING (3 questions)
  7. Keys and constraints (3 questions)
  8. Joining tables (3 questions)
  9. Relational algebra (3 questions)
  10. Subqueries and WITH (3 questions)
  11. CASE, views and set operations (3 questions)
  12. Designing a database: the ER model (3 questions)
  13. Normalization (3 questions)
  14. Indexes and how queries find rows (3 questions)
  15. Transactions and concurrency (3 questions)