GATE Computer Science (CS) 2017 Shift 2 Solved Paper
© examsiri.com
Question : 29 of 65
Marks:
+1,
-0
Consider the following tables T1 and T2.
T1
T2
In table T1, P is the primary key and Q is the foreign key referencing R in table T2 with on-delete cascade and on-update cascade. In table T2, R is the primary key and S is the foreign key referencing P in table T1 with on-delete set NULL and on-update cascade. In order to delete record (3, 8) from table T1, the number of additional records that need to be deleted from table T1 is ______.
T1
|
P |
Q |
|
2 |
2 |
|
3 |
8 |
|
7 |
3 |
|
5 |
8 |
|
6 |
9 |
|
8 |
5 |
|
9 |
8 |
T2
|
R |
S |
|
2 |
2 |
|
8 |
3 |
|
3 |
2 |
|
9 |
7 |
|
5 |
7 |
|
7 |
2 |
In table T1, P is the primary key and Q is the foreign key referencing R in table T2 with on-delete cascade and on-update cascade. In table T2, R is the primary key and S is the foreign key referencing P in table T1 with on-delete set NULL and on-update cascade. In order to delete record (3, 8) from table T1, the number of additional records that need to be deleted from table T1 is ______.
- Your Answer:
Go to Question: