UGC NET CSE | July 2018 | Part 2 | Question: 69

Question

Let $R_1(a, b, c)$ and $R_2(x, y, z)$ be two relations in which a is the foreign key of $R_1$ that refers to the primary key of $R_2$. Consider the following four options.

1. Insert into $R_1$
2. Insert into $R_2$
3. Delete from $R_1$
4. Delete from $R_2$

Which 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 1

Option (4) d and a will cause violation.

https://gateoverflow.in/2266/gate1997-6-10-isro2016-54

Comments

I think option D is correct..please see the option carefully..it asks about violation

---

Correct

---

answer will be $D$ only