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
State all possible different index configurations a table can possibly have?
How to update a table row with a record?
What is using clause and give example?
Is oracle the best database?
State the various uses of dbcc command?
What is the difference between substr and instr?
Compare and contrast between sql and sql server and explain its various functions?
How to load data from external tables to regular tables?
Explain the function of optimizer in oracle?
How to use subqueries with the in operator using oracle?
how to clone 9i Database on to 10g Database.
How to estimate disk space needed for an export job?
Differentiate between function and procedure in oracle.
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
How to assign values to variables?
