What is Referential Integrity?

Answers were Sorted based on User's Feedback



What is Referential Integrity?..

Answer / iain hambleton

Expanding on the two previous explanations, imagine any
parent/child relationship, for example a manufacturer and
product relationship that a retailer would have in it's
inventory system. Obviously any product must have been
manufactured by someone (i.e. a product cannot exist
without a manufacturer). Imagine then if in the inventory
system above, some muppet deleted records from the
manufacturer table. This would lead to products existing
in the system without a corresponding manufacturer record -
this is logically inconsistent data (as it does not fit
with the real world situation that the data is trying to
model).

If a foreign key constraint were to have been placed
between the two tables, then the muppet from above would
either have been unable to delete the manufacturer records
without first visiting the products table and deleting all
products that particular manufactures made or when the
manufacturers were deleted, all products linked to them
would have been automatically deleted also (this latter
situation is called a cascade delete – powerful and
dangerous stuff).

Either way, the remaining data would have been left
consistent with the real world manufacturer/product
relationship (though of course large swathes of data may
still have been deleted).

Is This Answer Correct ?    6 Yes 0 No

What is Referential Integrity?..

Answer / vasant

Referential integrity is a database concept that ensures
that relationships between tables remain consistent. When
one table has a foreign key to another table, the concept
of referential integrity states that you may not add a
record to the table that contains the foreign key unless
there is a corresponding record in the linked table. It
also includes the techniques known as cascading update and
cascading delete, which ensure that changes made to the
linked table are reflected in the primary table.

Is This Answer Correct ?    2 Yes 0 No

What is Referential Integrity?..

Answer / guest

Referential Integrity rule defines relationship between two
or more tables.Performing any operations on one table
affects another table automaticlly.Like EMP AND DEPT table
relationship.DEPTNO is a primary key in DEPT table and
Foreign key in EMP table.Only those DeptNo can be inserted
into EMP table which exists in DEPT table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

How do I run a script in sql developer?

0 Answers  


What is a Mapplet?

0 Answers   Informatica,


Can primary key be changed?

0 Answers  


Why we use pl sql?

0 Answers  


What are the different operators available in sql?

0 Answers  






hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  


What is the difference between a query and a report?

0 Answers  


What is the difference between clustered and non-clustered indexes?

0 Answers  


What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,


What is the difference between inner join and outer join?

0 Answers  


Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  


I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,


Categories