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
Answer
Correct Answer: 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
Detail about MCQs
The correct option is:
C. is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from the parent table is deleted.
The cascade delete option, when enabled in a database relationship, ensures that related records in child tables are automatically deleted when the corresponding record in the parent table is deleted. This helps maintain referential integrity within the database.