What Is On Delete Cascade?

1.	What Is On Delete Cascade?
Answer» When ON DELETE CASCADE is SPECIFIED Oracle maintains referential integrity by automatically removing DEPENDENT foreign key values if a referenced primary or unique key value is REMOVED. When ON DELETE CASCADE is specified Oracle maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

Answer»

When ON DELETE CASCADE is SPECIFIED Oracle maintains referential integrity by automatically removing DEPENDENT foreign key values if a referenced primary or unique key value is REMOVED.

When ON DELETE CASCADE is specified Oracle maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Components Of Logical Database Structure Of Oracle Database?
What Is A Tablespace?
What Is System Tablespace And When Is It Created?
Explain The Relationship Among Database, Tablespace And Data File.
What Are Schema Objects?
Can Objects Of The Same Schema Reside In Different Tablespaces?
Can A Tablespace Hold Objects From Different Schemes?
What Is Oracle Table?
What Is An Oracle View?
Do A View Contain Data?

What Is On Delete Cascade?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment