Pregunta de entrevista de Starling

How does cascade on delete work in SQL