Let R(a, b, c) and S(d, e, f) be two relations in which d is the foreign key…
ISRO Scientist/Engineer SC · 2016 · Computer ScienceModified — slightly modified from the official paper; see the solutionGATE · 1997 · CS · Question 6 subparts
Let R(a, b, c) and S(d, e, f) be two relations in which d is the foreign key of S that refers to the primary key of R. Consider the following four operations in R and S. I. Insert into R. II. Insert into S. III. Deletion from R. IV. Deletion from S. Which of the following can cause violation of the relational integrity constraint above?
- A.
Both I and IV
- B.
Both II and III
- C.
All of these
- D.
None of these
Attempted by 937 students.
Sign up free to check your answer
Sign up freeLoading lesson…