Morgan Stanley Interview Question

What is cascade delete in sql