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
what is a control file ? : Sql dba
What is primary key and foreign key?
What are the various levels of constraints?
Is it possible to read/write files to-and-from PL/SQL?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is a join?
What is form and report?
What are expressions?
What is a dirty read sql?
explain the difference between myisam static and myisam dynamic. : Sql dba
what are the differences between binary and varbinary? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
Explain correlated query work?
Can I learn sql in a week?
Does pl sql work in mysql?