Awesome q2a theme
0 votes
27 views

Consider the following table P and Q .In table P, A is Primary key and B is foreign key referencing C in table Q with on delete Cascade.In table Q C is primary key and D is foreign key referencing A in table P with on delete Cascade.in order to delete record (2,6) from the table P.the number of additional records that need to be deleted from table Q ia/are:________.

A B
1 1
2 6
7 2
5 6
8 9
6 5
9 6
   
(Q
C D
1 1
6 2
2 1
9 7
5 9
7 1

Last row of P is blanck by mistake it is added..ignore it)

in Databases by (25 points) | 27 views
0
I get answer--> 2 . It is true?
+1
yes.

1 Answer

+2 votes
Best answer
As you will Delete P(2,6) now the row in Q which have D value 2 will get deleted as On delete Cascade is applied.

P(2,6)-Q(6,2)-P(5,6),P(9,6)-Q(5,9)-P(6,5) so from Q 2 data get deleted.
by (199 points)
selected ago by
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
8,968 questions
3,119 answers
14,340 comments
95,792 users