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 the difference between alter trigger and drop trigger statements?

599


What is denormalization in a database?

585


Write a sql query to convert all character to uppercase after hypen.

955


Why do we use joins in sql?

496


What is the difference between function and procedure in pl/sql?

531






what is index? : Sql dba

554


What are the advantages of sql?

556


How to test for null values?

598


how many columns can be used for creating index? : Sql dba

511


What is the difference between sql and mysql?

545


What is difference between db2 and sql?

526


What is a full join?

519


What is pl sql collection?

514


Can you rollback after commit?

519


How can I change database name in sql?

521