Describe the delete cascade option (for implementing a referential integrity constraint)

What will be an ideal response?

The delete cascade option allows a record to be deleted if its primary key value is referred to by a foreign key value. However, all the records whose foreign key value refers to the primary key value of the record that is being deleted will also be deleted.