Let R1(a, b, c) and R2(x, y, z) be two relations in which a is the foreign key of R1 that refers to the primary key of R2. Consider following four options.(a) Insert into R1 (b) Insert into R2(c) Delete from R1 (d) Delete from R2Which of the following is correct about the referential integrity constraint with respect to above?

Question

Let R1(a, b, c) and R2(x, y, z) be two relations in which a is the foreign key of R1 that refers to the primary key of R2. Consider following four options.(a) Insert into R1           (b) Insert into R2(c) Delete from R1        (d) Delete from R2Which of the following is correct about the referential integrity constraint with respect to above?

TuteeHUB · Accepted Answer

NA

TuteeHUB · Answer

Operations (a) and (b) will cause violation.

TuteeHUB · Answer

Operations (b) and (c) will cause violation.

TuteeHUB · Answer

Operations (c) and (d) will cause violation.

TuteeHUB · Answer

Operations (d) and (a) will cause violation.

1.	Let R1(a, b, c) and R2(x, y, z) be two relations in which a is the foreign key of R1 that refers to the primary key of R2. Consider following four options.(a) Insert into R1 (b) Insert into R2(c) Delete from R1 (d) Delete from R2Which of the following is correct about the referential integrity constraint with respect to above?
A.	Operations (a) and (b) will cause violation.
B.	Operations (b) and (c) will cause violation.
C.	Operations (c) and (d) will cause violation.
D.	Operations (d) and (a) will cause violation.
Answer» E.

Discussion

No Comment Found

Related MCQs

Reply to Comment