Pergunta de entrevista da empresa Starling

How does cascade on delete work in SQL