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 oracle rownum?
What is the oracle implicit cursor?
what are the advantages of running a database in archive log mode?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is the fastest query method to fetch data from the table?
How to manage transaction isolation level?
How to define an oracle sub procedure?
How to write text literals in oracle?
What happens to the data files if a tablespace is dropped?
How to define an explicit cursor in oracle?
What are the attributes of cursor?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Give syntax for SQL and ORACLE joins.
What is recycle bin in Oracle?
What do you mean by a deadlock?