Consider the following table has 2 attributes A,B where A is the PK (primary key) and B is the FK (foreign key) referencing it with on delete cascade.
|
A |
B |
|
2 |
4 |
|
4 |
3 |
|
3 |
4 |
|
7 |
2 |
|
5 |
2 |
|
6 |
4 |
|
9 |
5 |
The set of tuples that must be additionally deleted to preserve referential integrity constraint (FK constraint) when the tuple (2, 4) deleted is
1
(5,2), (4,3), (3,4)
2
(5,2), (7,2), (9,5)
3
(7,2),(6,4),(4,3)
4
none of the above
5
Question Not Attempted