...
Functions
August 29, 2024
Database-Management-System
August 29, 2024
Functions
August 29, 2024
Database-Management-System
August 29, 2024

Database-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

A
0
B
1
C
2
D
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.
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!