DATA WAREHOUSE Questions and Answers

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.