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 PL/SQL Records?

631


What is the usage of the distinct keyword?

692


what is “go” in t-sql? : Transact sql

606


Explain constraints in sql?

575


Why do we need pl sql?

550






what is self-join? : Sql dba

573


what are properties of a transaction? : Sql dba

562


How delete all records from table in sql?

556


How to Execute a Package in PL/SQL.?

589


What is a table in a database?

584


What is the difference between between and in condition operators?

539


how to get a list of indexes of an existing table? : Sql dba

518


Is sql a case sensitive language?

520


How many types of primary keys are there?

533


what are the types of subquery? : Sql dba

592