Question · SQL and MySQL course · Module 4: Creating tables (DDL)

PRIMARY KEY versus UNIQUE

How many UNIQUE columns can a single table have?

Answer options

  • Many - unlike PRIMARY KEY, of which there is only one
  • Only one, just like PRIMARY KEY
  • None - UNIQUE is forbidden in MySQL
  • Exactly two

You can check the correct answer by solving this task in the CodeWorlds game.