Open In App
Related Articles

GATE | GATE-CS-2005 | Question 76

Improve Article
Save Article
Like Article

The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with on-delete cascade.

A   C
2   4
3   4
4   3
5   2
7   2
9   5
6   4 

The set of all tuples that must be additionally deleted to preserve referential integrity when the tuple (2,4) is deleted is:
(A) (3,4) and (6,4)
(B) (5,2) and (7,2)
(C) (5,2), (7,2) and (9,5)
(D) (3,4), (4,3) and (6,4)

Answer: (C)

Explanation: See question 2 of

Quiz of this Question

Level Up Your GATE Prep!
Embark on a transformative journey towards GATE success by choosing Data Science & AI as your second paper choice with our specialized course. If you find yourself lost in the vast landscape of the GATE syllabus, our program is the compass you need.

Last Updated : 28 Jun, 2021
Like Article
Save Article
Similar Reads