Multiple choice

Consider a relation geq which represents “greater than or equal to”, that is, (x,y) $\epsilon$geq only if y $\le$ x: Create table gaq (Ib integer not null ub integer not null primary key Ib foreign key (ub) references geq on delete cascade):

Which of the following is possible if a tuple (x,y) is deleted?

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

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

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

  4. The deletion of (x,y) is prohibited.

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation