Interested to Buy Any Domain ? << Click Here >> for more details...
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 are all the common sql function? : Sql dba
what happens if you no create privilege in a database? : Sql dba
What is a mutating table and a constraining table?
what are the limitations of identity column? : Transact sql
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
How do I view an execution plan in sql?
What is mutating sql table?
What is the use of %rowtype?
What is a trigger in sql?
what is user defined functions? : Sql dba
What are the types of views in sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
How can we store rows in PL/SQL using array?
What does trigger mean in slang?
what are rollup and cube in t-sql? : Transact sql
