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 |
Difference between varchar and varchar2 data types?
various types of hints and their usage
How to apply filtering criteria at group level in oracle?
what is null value?
what is the syntax of UPDATE command?
What is Virtual Private Database in Oracle?
What is Row Chaining ?
material view and view disadvantages?
How do we get field details of a table?
What is instant client oracle?
Can you use a commit statement within a database trigger?
Can we create index on views?
19 Answers CTS, Syntel, TCS,