Domanda di colloquio di Starling

How does cascade on delete work in SQL