MCQ Single Best Answer Easy

QWhich of the following values for the On Delete property for a relation specifies to only permit deletion of records in a table when there is nothing that relates to it in another table?

ID: #9357 Module 8: Table Relations 171 views

Question Info

#9357Q ID

EasyDifficulty

Module 8: Table RelationsTopic

Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

Correct Answer: Option A

Justification:

When the value Restricted is set for the On Delete property, records can only be deleted from the table when there is nothing that relates to it in another table.
The Cascade property value specifies to delete the selected row in the table, along with all data in relating tables
The Cascade + Restricted property value will perform a cascade delete, meaning the data will be deleted despite records existing in relating tables. However, a warning will appear first providing the user with the option to confirm or deny the cascade delete action.
When the property value is set to None, it allows the row in the table to be deleted, but does nothing to records in related tables.