waht is referencial integrity?
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 |
What is a trace file and how is it created in oracle?
What is the difference between formal parameters and actual parameters?
12 RULES OF RDBMS
How to use an explicit cursor without open statements?
What is bulk load in oracle?
What are joins..how many types of joins are there?
29 Answers Amdocs, CSC, TCS,
how to store only time in a data base table
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What do you mean by redo log file mirroring?
How to set up autotrace for a user account?
Describe the different type of Integrity Constraints supported by ORACLE ?
How translate command is different from replace?