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 to do if the binary spfile is wrong for the default instance?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
What is the difference between truncate & delete command?
How to retrieve data from an explicit cursor?
Give syntax for SQL and ORACLE joins.
What is the purpose of a cluster?
Difference between varchar and varchar2 data types?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
How do we display rows from the table without duplicates?
How to export several tables together?
What are various constraints used in SQL?
What is sequence?