Functions
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 302 |
Consider the following tables Tl and T2:
In table Tl, 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 Tl with on-delete set NULL and
on-update cascade. In order to delete record (3,8) from table, number of additional
records that need to be deleted from table T1 is
| 0 | |
| 1 | |
| 2 | |
| 3 |
Question 302 Explanation:
Row (3,8) is deleted from T1 , so in T2 whichever rowS contains 3 will be replaced with null for only S value of that row due to condition “on-delete set NULL” .And no further modification in any of the table is required.
Correct Answer: A
Question 302 Explanation:
Row (3,8) is deleted from T1 , so in T2 whichever rowS contains 3 will be replaced with null for only S value of that row due to condition “on-delete set NULL” .And no further modification in any of the table is required.