Starling Interview Question

How does cascade on delete work in SQL