Design and safety quiz

  • Admin
  • 1 min read

Nine questions on keys, constraints, indexes, transactions and views.

SQL

Design and safety quiz

9 questions, instant feedback

Question 1 of 9 What does a primary key guarantee?
Question 2 of 9 What does a foreign key enforce?
Question 3 of 9 Which constraint prevents an empty value?
Question 4 of 9 What is an index for?
Question 5 of 9 Which columns benefit most from an index?
Question 6 of 9 What does a transaction guarantee?
Question 7 of 9 What is a view?
Question 8 of 9 What does ON DELETE CASCADE do?
Question 9 of 9 Which first step limits the damage of a DELETE?

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