Interested to Buy Any Domain ? << Click Here >> for more details...
waht is referencial integrity?
- 2 Answers
- 7657 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / arijitnit
Referential integrity in a relational database is
consistency between coupled tables. Referential integrity is
usually enforced by the combination of a primary key or
candidate key (alternate key) and a foreign key. For
referential integrity to hold, any field in a table that is
declared a foreign key can contain only values from a parent
table's primary key or a candidate key. For instance,
deleting a record that contains a value referred to by a
foreign key in another table would break referential
integrity. The relational database management system (RDBMS)
enforces referential integrity, normally either by deleting
the foreign key rows as well to maintain integrity, or by
returning an error and not performing the delete. Which
method is used would be defined by the definition of the
referential integrity constraint.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / manisha
Referential integrity is a database concept that ensures
that relationships between tables remain consistent. When
one table has a foreign key to another table, the concept
of referential integrity states that you may not add a
record to the table that contains the foreign key unless
there is a corresponding record in the linked table. It
also includes the techniques known as cascading update and
cascading delete, which ensure that changes made to the
linked table are reflected in the primary table.
| Is This Answer Correct ? | 3 Yes | 2 No |
12 RULES OF RDBMS
what are the things that you consider while creating indexes on partitioning tables?
what are the diffeenes between oracle 9i,oracle 10g
What are the attributes of the cursor?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
What is proxy method?
What are the different type of Segments ?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
what is data independence exactly? give an example
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to convert csv to table in oracle?
Is it possible to split the print reviewer into more than one region ?
Oracle General 
