The following table has two attributes A and C where A is the primary key and…

GATE · 2005 · CS

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:

  1. A.

    (3,4) and (6,4)

  2. B.

    (5,2) and (7,2)

  3. C.

    (5,2), (7,2) and (9,5)

  4. D.

    (3,4), (4,3) and (6,4)

Attempted by 960 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…