What is referential integrity ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do we use sql constraints?

664


what are the disadvantages of mysql? : Sql dba

577


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

547


What is mdb stand for?

560


Why cross join is used?

637






What is a schema sql?

533


What does bitemporal mean?

602


Name some usages of database trigger?

566


Is sql easier than java?

529


How do you break a loop in pl sql?

529


How can check sql version from command line?

536


What is difference between primary and secondary key?

520


What is scalar data type in pl sql?

564


What are the indexing methods?

582


What is sql architecture?

561