Data Warehousing Interview Questions and Answer Part – 7

61) What are the Referential actions supported by FOREIGN KEY integrity constraint?
Update And Delete Restrict – A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade – When a referenced row is deleted all associated dependent rows are deleted.

Leave a Reply

Your email address will not be published. Required fields are marked *