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.
Subscribe
Login
0 Comments