What is Referential Integrity?

Answers were Sorted based on User's Feedback



What is Referential Integrity?..

Answer / suriyaraj

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 ?    7 Yes 1 No

What is Referential Integrity?..

Answer / rajeshwaran

It is a rule defined on a column or a set of columns that
allows to insert or update a value in a table that matches
with the values in the corresponding columns of the related
tabels.

Is This Answer Correct ?    6 Yes 2 No

What is Referential Integrity?..

Answer / dhirendra

Referential Integrity means: Whenever parent values are
available, the user can not transact it to Transaction table.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

what is the forward decleration in packages?

1 Answers  


how to get enames with comma seperated values by deptwise on emp table?

8 Answers  


Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,


What are the datatypes a available in PL/SQL ?

2 Answers  


Can you have a foreign key without a primary key?

0 Answers  






What is difference between stored procedure and trigger?

0 Answers  


What do you understand by case manipulation functions?

0 Answers  


What are Global Temporary tables

3 Answers   IBM, TCS,


Does postgresql run on the cloud?

0 Answers  


Why do we use procedures?

0 Answers  


Why is stored procedure faster than query?

0 Answers  


What is primary key and foreign key with example?

0 Answers  


Categories