Answer Posted / 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 |
Post New Answer View All Answers
How would you begin to troubleshoot an ORA-3113 error?
How to generate query output in html format?
Explain a data segment?
How to shutdown your 10g xe server from command line?
How to use existing values in update statements using oracle?
Why cursor variables are easier to use than cursors?
How to connect to the server with user account: sys?
material view and view disadvantages?
Can multiple cursors being opened at the same time?
Is truncate autocommit in oracle?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
what is the difference between data migration and production migration.
What happens to the current transaction if the session is ended?
Can sub procedure/function be called recursively?
How to empty your oracle recycle bin?
