The correct answer is: B. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted.
Cascade delete is a feature in Microsoft Access that allows you to delete records from a child table automatically when you delete a record from the parent table. This can be useful if you have a one-to-many relationship between two tables, and you want to make sure that all of the records in the child table are deleted when you delete a record in the parent table.
For example, let’s say you have a table of customers and a table of orders. Each customer can have multiple orders, but each order can only belong to one customer. In this case, you would set up a one-to-many relationship between the two tables.
If you then enable cascade delete on the relationship, when you delete a customer from the customer table, all of the orders for that customer will be automatically deleted from the order table.
Cascade delete can be a useful tool, but it’s important to use it carefully. If you delete a record from the parent table by mistake, you could end up deleting a lot of records from the child table that you didn’t mean to delete.
Here are some additional details about each option:
- Option A: This option is incorrect because it would delete all of the records from both the parent table and the child table. This is not what cascade delete is designed to do.
- Option B: This option is correct because it describes what cascade delete actually does. When you delete a record from the parent table, all of the related records in the child table will be automatically deleted.
- Option C: This option is incorrect because it describes the opposite of what cascade delete does. When you delete a record from the child table, no records in the parent table will be automatically deleted.
- Option D: This option is incorrect because it does not describe any of the options that are actually available.