COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Referential
|
|
|
Referencing
|
|
|
Primary
|
|
|
None of the above
|
Detailed explanation-1: -A Referential integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
Detailed explanation-2: -A referential integrity constraint requires that the values appearing in specied attributes of any tuple in the referencing relation also appear in specied attributes of at least one tuple in the referenced relation. In above table, DeptNo is the primary key of Dept and it is foreign key of EMP table.
Detailed explanation-3: -Foreign Key Constraint OR Referential Integrity constraint.
Detailed explanation-4: -Integrity constraints in DBMS are used to ensure that data is consistent and accurate. There are four main types of integrity constraints: domain, entity, referential, and key.
Detailed explanation-5: -Referential Integrity is used to maintain the consistency among tuples of the two relations. The referential integrity constraint states that a tuple in one relation that refers to another relation must refer to an existing tuple in that relation.