closed by
827 views
1 votes
1 votes
closed as a duplicate of: GATE CSE 2001 | Question: 2.25

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

closed by

Related questions

7 votes
7 votes
3 answers
2
go_editor asked Feb 8, 2018
2,040 views
Consider a relation examinee (regno, name, score), where regno is the primary key to score is a real number.Write an SQL query to list the regno of examinees who have a s...