The correct answer is C. Cascade delete option is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted.
Option A is incorrect because cascade delete option is not used to delete all the records of all tables in a database. It is only used to delete the records that are related to the record that is being deleted.
Option B is incorrect because cascade delete option will not repeat the recent delete operation to all the records of current table. It will only delete the records that are related to the record that is being deleted.
Option D is incorrect because cascade delete option is available in Edit relationship dialog box.