# GATE Solved Paper 2017-19 - GATE 2017 Shift 2

>>>>>>>>GATE 2017 Shift 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 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 _____.
Note – Numerical Type question

• Option : A
• Explanation :
As Q refers to R so, deleting 8 from Q won't be an issue, however, S refers P. But as the relationship given is on delete set NULL, 3 will be deleted from T1 and the entry in T2 having 3 in column S will be set to NULL. So, no additional records deleted from table T1

• Option : B
• Explanation :
Next pointer of the front node would point to the second node, if any.

• Option : C
• Explanation :
Sign = 0
= +ve
AE= BE-Bias
= 01111100-01111111
AE= 11111101
Here sign of AE is negative so take two's complement of AE = 00000011
Mantissa: Normal Mantissa = 1.M = 1.1101101
Data + 1.1101101 x 2-3
Hence answer is 2.27 x 10-1

• Option : C
• Explanation :

Note: only M to N relationship needs exclusive table: If a relationship is 1 to M or M to 1 then that relation could be included in the many side table with the help of foreign key concept.
Related Quiz.
GATE 2017 Shift 2