Quiz: Unique Indexes and Unique Constraints in SQL Server

Photo by Cristina Gottardi on Unsplash

Quiz: Unique Indexes and Unique Constraints 😜

They're not quite twins
  • Check all that apply
  • Choose all that apply
  • I checked, and the values populated for existing rows are already unique. We want to enforce this rule for the future.

Want to read more?

I wrote a post about the differences between unique indexes and unique constraints here.

4 thoughts on “Quiz: Unique Indexes and Unique Constraints in SQL Server

  1. Aaagghhh!
    Messed up Q4.
    It’s like my MCITP exams all over again: actually READ the question!

  2. Finally, a solid Solid B+
    Is the first time afther months of Kendra’s quiz.

  3. This quiz has no sense of humour 🙁 My answer for number 4 was “Only on Friday” and it was marked wrong 🙁 🙁
    On Fridays after a few beers all commands run successfully 🙂

  4. If only unique indexes showed in SQL Server Management Studio with the same alternate key icon as a unique constraint… I find that using unique constraints is more helpful in making the database design self documenting.

Leave a Reply

Your email address will not be published. Required fields are marked *