Skills101
← All practice quizzes

Quiz: Keys and Constraints

5 questionsNo time limitPass: 60%+10 XP on first pass

Every type of key with one clear picture, plus SQL constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, CHECK, DEFAULT) that keep data correct.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    A minimal super key is called a:

  2. Question 2

    How many primary keys can a table have?

  3. Question 3

    Which is true about a foreign key?

  4. Question 4

    Which constraint stops a salary of -500 from being inserted?

  5. Question 5

    Candidate keys that are not chosen as the primary key are called: