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

How to execute a stored program unit?

594


How to convert character types to numeric types?

588


What is logical backup in oracle?

582


What is user managed backup in Oracle?

622


What is tns name?

553






What is the disadvantage of User defind function?

1845


Can we call procedure inside function in oracle?

622


How to synchronize 2 schema's objects?

1701


Explain oracle’s system global area (sga).

634


Explain overloading. Can functions be overloaded?

581


How to use subqueries with the exists operator in oracle?

614


Can we insert data in view oracle?

547


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1705


Is insert autocommit in oracle?

616


Is rowid unique in oracle?

541