Gate CS-2017-2 Question Paper With Solutions

Q. 21 Consider the following tables T1 and T2:

Gate CS-2017-2 Question Paper With Solutions

In table T1, P is the primary key, 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 the table T1 with on-delete set NULL and on-update cascade. In order to delete record (3,8) from table, numbers of additional record that need to be deleted from table T1 is ______.

Note: This question appeared as Numerical Answer Type.

(A) 0

(B) 1

(C) 2

(D) 3

Answer: (A)

Explanation:

Gate CS-2017-2 Question Paper With Solutions

Learn More:   Gate EC-2014 - 2 Question Paper With Solutions

LEAVE A REPLY

Please enter your comment!
Please enter your name here