What Are The Referential Actions Supported By Foreign Key Integrity C

1.	What Are The Referential Actions Supported By Foreign Key Integrity Constraint ?
Answer» 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. 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.

What Are The Referential Actions Supported By Foreign Key Integrity Constraint ?

Answer»

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Values That Can Be Specified For Optimizer Mode Parameter ?
What Is A Trace File And How Is It Created ?
How Many Number Of Columns A Record Group Can Have?
What Does The Term Panel Refer To With Regard To Pages?
What Is A Master Detail Relationship?
What Is A Library?
What Erase Package Procedure Does ?
What Is Mean By Program Global Area (pga) ?
What Is The Use Of Parfile Option In Exp Command ?
What Is Overloading Of Procedures ?

What Are The Referential Actions Supported By Foreign Key Integrity Constraint ?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment