Cascade delete option A. is used to delete all the records of all tables in a database B. will repeat the recent delete operation to all the records of current table C. 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 D. None of above

is used to delete all the records of all tables in a database
will repeat the recent delete operation to all the records of current table
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
None of above

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.