What is Referential Integrity?

Answer Posted / guest

Referential Integrity rule defines relationship between two
or more tables.Performing any operations on one table
affects another table automaticlly.Like EMP AND DEPT table
relationship.DEPTNO is a primary key in DEPT table and
Foreign key in EMP table.Only those DeptNo can be inserted
into EMP table which exists in DEPT table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is nosql vs sql?

874


What is difference between rank () row_number () and dense_rank () in sql?

804


How do you rank data in sql?

680


How you improve the performance of sql*loader? : aql loader

752


What are the advantages of sql? Explain

850






Does truncate free space?

711


Is sql microsoft?

710


Is nosql relational?

707


Explian rowid, rownum?

752


Can I learn sql in a week?

753


What is the advantage of nosql?

733


What does select count (*) mean in sql?

739


what is bcp? When does it used? : Sql dba

706


How to rename a table?

766


What is the main difference between sql and pl/sql?

757