GATEverse
← GATE CSE 2017 Set 2

Q19

NAT1 mark

Consider the following tables T1T1 and T2.T2.

PQ22 3873586 98598T1RS22 8332975 772T2\overset{T1}{\begin{array}{|c|c|c|} \hline \textbf {P} & \textbf {Q} \\\hline \text {2} & \text{2 }\\\hline \text{3} & \text{8} \\\hline \text{7} & \text{3} \\\hline \text{5} & \text{8} \\\hline \text{6 } &\text{9} \\\hline \text{8} & \text{5} \\\hline \text{9} & \text{8} \\\hline \end{array}} \qquad \overset{T2}{\begin{array}{|c|c|c|} \hline \textbf {R} & \textbf {S} \\\hline \text {2} & \text{2 }\\\hline \text{8} & \text{3} \\\hline \text{3} & \text{2} \\\hline \text{9} & \text{7} \\\hline \text{5 } &\text{7} \\\hline \text{7} & \text{2} \\\hline \end{array}}

In table T1T1 P is the primary key and Q is the foreign key referencing R in table T2T2 with on-delete cascade and on-update cascade. In table T2,T2, R is the primary key and S is the foreign key referencing P in table T1T1 with on-delete set NULL and on-update cascade. In order to delete record ⟨3,8⟩\langle 3, 8 \rangle from the table T1,T1, the number of additional records that need to be deleted from table T1T1 is _______

Sign in to save attempts.

Loading…