UGC NET CS 2018 July - II Question 69

69. 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 R2
Which of the following is correct about the referential integrity constraint with respect to
above ?
(1) Operations (a) and (b) will cause violation.
(2) Operations (b) and (c) will cause violation.
(3) Operations (c) and (d) will cause violation.
(4) Operations (d) and (a) will cause violation.

Answer: 4

Previous	Next
UGC NET CS 2018 July - II Question 68	UGC NET CS 2018 July - II Question 70