Consider the following tables T1 and T2 In table T1, P is the primary key and…

PYQ GATE 2017

Consider the following tables T1 and 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 the table T1, the number of additional records that need to be deleted from table T1 is _______

Attempted by 369 students.

Sign up free to check your answer

Sign up free

Explore the full course: Zero To Hero

Loading lesson…