Describe Referential Integrity ?

Answer Posted / orawhiz

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 ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of ignore option in imp command.

577


Which are the five query types available in oracle?

532


How to save query output to a local file?

563


What are the differences between interval year to month and interval day to second?

554


Please explain compound trigger in oracle?

603






What is bind variable in oracle 11g?

593


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1793


How to use null as conditions in oracle?

585


What is difference between truncate and delete?

567


How do I recompile a procedure in oracle?

529


What is the implicit cursor in oracle?

570


What is execute immediate in oracle?

549


What is key preserved table?

569


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1609


What is primefaces used for?

559