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 the use of indexes option in imp command.
What is analyze command used for?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
How to create a table interactively?
What is oracle data type?
What is the difference between sharding and partitioning?
What is the difference between $oracle_base and $oracle_home?
How to rename a tablespace in oracle?
How to run create database statement again?
Is there a function to split a string in plsql?
How to put more than 1000 values into an oracle in clause?
How to list all indexes in your schema?
How to end the current transaction in oracle?
Explain the use of full option in exp command.
What is backup in Oracle?
