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

How PRIMARY KEY works

What does a PRIMARY KEY constraint placed on the id column guarantee?

Answer options

  • The value is automatically encrypted
  • The value is unique and cannot be empty - it uniquely identifies the row
  • The column accepts only text
  • The column may be empty, but not repeated

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