Quiz

Database quiz: indexes, ACID, joins and normalization

A database quiz on indexes and B-trees, DELETE without WHERE, ACID and durability, joins, deadlocks and normalisation, with each idea explained in depth.

  • 7 min read
  • 10 questions
  • +60 XP
Transcript

Database quiz hosted by cats. What does SQL stand for? What happens if you forget WHERE clause in a DELETE? What is a primary key? Which command changes existing data What causes a deadlock? What does ACID stand for? Which operation is usually the most expensive?

What is normalization mainly used for? What happens when you add too many indexes? Which index type is best for range queries? What was your score out of 10?