Consider a relation geq which represents “greater than or equal to”, that is, (x,y) ∈ geq only if y = x.create table geq( ib integer not null ub integer not null primary key 1b foreign key (ub) references geq on delete cascade )Which of the following is possible if a tuple (x,y) is deleted?

Question

Consider a relation geq which represents “greater than or equal to”, that is, (x,y) ∈ geq only if y >= x.create table geq(   ib integer not null  ub integer not null  primary key 1b  foreign key (ub) references geq on delete cascade )Which of the following is possible if a tuple (x,y) is deleted?

TuteeHUB · Accepted Answer

The deletion of (x,y) is prohibited

TuteeHUB · Answer

A tuple (z,w) with z > y is deleted

TuteeHUB · Answer

A tuple (z,w) with z > x is deleted

TuteeHUB · Answer

A tuple (z,w) with w < x is deleted

1.	Consider a relation geq which represents “greater than or equal to”, that is, (x,y) ∈ geq only if y >= x.create table geq( ib integer not null ub integer not null primary key 1b foreign key (ub) references geq on delete cascade )Which of the following is possible if a tuple (x,y) is deleted?
A.	A tuple (z,w) with z > y is deleted
B.	A tuple (z,w) with z > x is deleted
C.	A tuple (z,w) with w < x is deleted
D.	The deletion of (x,y) is prohibited
Answer» D. The deletion of (x,y) is prohibited

Consider a relation geq which represents “greater than or equal to”, that is, (x,y) ∈ geq only if y >= x.create table geq( ib integer not null ub integer not null primary key 1b foreign key (ub) references geq on delete cascade )Which of the following is possible if a tuple (x,y) is deleted?

Discussion

No Comment Found

Related MCQs

Reply to Comment