Interested to Buy Any Domain ? << Click Here >> for more details...
waht is referencial integrity?
- 2 Answers
- 7549 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 |
ABOUT IDENTITY?
How to do paging with oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to Remove the 3rd highest salary person record from table?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
What is set operator oracle?
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
Which database is better for os platform dependency?
What are a collation and state the different types of collation sensitivity?
DBMS vs. RDBMS
what is port in oracle? how is it related to database application.
Why we choose emp number as primarykey?
Oracle General 
