What is referential integrity ?

Answers were Sorted based on User's Feedback



What is referential integrity ?..

Answer / rajesh

To establish a parent child relationship between two tables
and to prevent invalid data entry into the table , we make
set of rules on a column is called Referential integrity.

Is This Answer Correct ?    5 Yes 0 No

What is referential integrity ?..

Answer / mallikarjuna.anumala

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to
be performed on dependent data as a result of any action on
referenced data.

Is This Answer Correct ?    3 Yes 0 No

What is referential integrity ?..

Answer / pravin kadam

A rule defined on a column (or set of columns) in one table
that allows the insert or update of a row only if the value
for the column or set of columns (the dependent value)
matches a value in a column of a related table (the
referenced value). It also specifies the type of data
manipulation allowed on referenced data and the action to
be performed on dependent data as a result of any action on
referenced data.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is bulk collections?

2 Answers  


how to get second highest salary in SQL(as/4000

29 Answers   iGate,


How much does sql cost?

0 Answers  


can i write pl/sql code in a package

2 Answers  


How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,






Which one is faster ienumerable or iqueryable?

0 Answers  


What is the best sql course?

0 Answers  


Explain the difference between sql and mysql.

0 Answers  


What does over partition by mean in sql?

0 Answers  


Is sql database free?

0 Answers  


What is difference between mysql and postgresql?

0 Answers  


Why truncate is faster than delete?

0 Answers  


Categories