Starling interview question

How does cascade on delete work in SQL