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

ON DELETE CASCADE

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

Answer options

  • It will set the books' autor_id to NULL
  • It will automatically delete all books linked to that author
  • It will block deleting the author forever
  • It will copy the author to another table

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