- A Restricted
- B Cascade
- C Cascade + Restricted
- D None
- Share this MCQ
Answer:
A
Share this MCQ
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.
Related Lesson: Relations
Click me to Read more Question & Answer of Module 7: Table IndexesShare this MCQ