Interested to Buy Any Domain ? << Click Here >> for more details...
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 to login to the server without an instance?
What happens to indexes if you drop a table?
Explain the use of constraints option in exp command.
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Query to retrieve record for a many to many relationship ?
Explain what are the uses of rollback segment?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to pass parameters to procedures?
Can a formula column referred to columns in higher group ?
How to retrieve data from an explicit cursor?
How can windows applications connect to oracle servers?
How to initialize variables with default values?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What happens in oracle commit?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
