Answer Posted / 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 |
Post New Answer View All Answers
What is Virtual Private Database in Oracle?
What is archive log in Oracle?
How to create a single index for multiple columns?
Explain how you would restore a database using RMAN to Point in Time?
What is a dead lock in oracle?
What is Reduced List of Values?
Explain the function of optimizer in oracle?
Explain the use of compress option in exp command.
Differentiate between translate and replace?
What are the oracle built-in data types?
What are the major difference between truncate and delete?
What is a system tablespace?
what is the difference between functional dependecy and multilevel dependency?
How do you tell what your machine name is and what is its IP address?
How many types of database triggers exist?