What is referential integrity ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What is bulk collections?
how to get second highest salary in SQL(as/4000
How much does sql cost?
can i write pl/sql code in a package
How well can multiple sessions access the same data simultaneously ?
Which one is faster ienumerable or iqueryable?
What is the best sql course?
Explain the difference between sql and mysql.
What does over partition by mean in sql?
Is sql database free?
What is difference between mysql and postgresql?
Why truncate is faster than delete?