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 |
How would you design a database for an e-commerce website?
How to see the table columns used in an index?
Shall I get Pro*C Compiler in Oracle-10g release ?
How to call a stored function with parameters?
What are the different types of database objects?
Give the advantages and disadvantages of clusters.
How to sort the query output in oracle?
what is a view?
What is transaction control statement and how many types of transaction control statement in Oracle?
which sql command we can use to get a print out from oracle?
How can you merge two tables in oracle?
What is a Temporary Segment ?