Morgan Stanley interview question

What is cascade delete in sql