Gate CS-2005 Question Paper With Solutions

Q. 76 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:

Gate CS-2005 Question Paper With Solutions

Learn More:   Gate CS-2017-2 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here