Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain how are indexes update?
What is the usage of save points in oracle database?
Respected sir, Please send me technical questions related to oracle apps..
How to drop a stored function?
What is control file used for?
How to use "if" statements on multiple conditions?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What happens if you use a wrong connect identifier?
How to use null as conditions in oracle?
What is bulk collect in oracle?
Explain drop constraint oracle?
How to load excel data sheet to oracle database
What are the common oracle dba tasks?
What is difference between truncate and delete?
Can we create trigger on materialized view in oracle?
