Question · SQL and MySQL course · Module 9: Indexes and normalization

ON DELETE SET NULL

What will the ON DELETE SET NULL rule do when an author is deleted?

Answer options

  • It will keep the books but set their autor_id column to NULL (no assigned author)
  • It will delete all of that author's books
  • It will delete the whole ksiazki table
  • It will change the type of the autor_id column

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