Answer Posted / arijitnit
Referential integrity in a relational database is
consistency between coupled tables. Referential integrity is
usually enforced by the combination of a primary key or
candidate key (alternate key) and a foreign key. For
referential integrity to hold, any field in a table that is
declared a foreign key can contain only values from a parent
table's primary key or a candidate key. For instance,
deleting a record that contains a value referred to by a
foreign key in another table would break referential
integrity. The relational database management system (RDBMS)
enforces referential integrity, normally either by deleting
the foreign key rows as well to maintain integrity, or by
returning an error and not performing the delete. Which
method is used would be defined by the definition of the
referential integrity constraint.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Why use resource manager in Oracle?
Differentiate between post-database commit and post-form commit?
Is there a combination of "like" and "in" in sql?
What is a user account in oracle?
How do we represent comments in oracle?
What are internal user account in oracle?
How to use attributes of the implicit cursor in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Who developed oracle & when?
What are set operators?
What is null value in oracle?
What is different types of joins?
Can objects of the same schema reside in different tablespace?
What is the difference between Delete, Truncate and Drop in Oracle?
How do I know if oracle is installed on windows?
