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.

(2118)

Leave a Reply