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

2005

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.

image.png


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 510 students.

Show answer & explanation

Correct answer: C

image.png

A video solution is available for this question — log in and enroll to watch it.

Explore the full course: Gate Guidance By Sanchit Sir