UGC NET PAPER 2 June 2019 Question 39 (Shift-I)

39. Following table has two attributes Employee_id and Manager_id, where Employee_id is a primary key and manager_id is a foreign key referencing Employee_id with on-delete cascade:

Employee_id	Manager_id
20	40
25	40
30	35
35	20
40	45
45	25

On deleting the table (20,40), the set of other tuples that must be deleted to maintain the referential integrity of table is

A (30,35) only

B (30,35) and (35,20) only

C (35,20) only

D (40,45) and (25,40) only

ANS. B

Previous	Next
UGC NET CS 2018 July - II Question 38	UGC NET CS 2018 July - II Question 40