Describe Referential Integrity ?
Answer / 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 |
What is logical backup in oracle?
How to open and close an explicit cursor in oracle?
Explain the use of compress option in exp command.
What is meant by joins? List out the types of joins.
What is rowid and rownum in oracle?
How to use attributes of the implicit cursor in oracle?
How to synchronize 2 schema's objects?
what is the difference between restoring and recovering?
what is the syntax of ALTER command?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
How to apply filtering criteria at group level in oracle?
What is Row Chaining ?