Test Index

GATE Computer Science (CS) 2022 Shift 1 Solved Paper

© examsnet.com

Question : 55 of 65

Marks: +1, -0

Consider the relational database with the following four schemas and their respective instances.

Student(sNo, sName, dNo) Dept(dNo, dName)

Course(cNo, cName, dNo) Register(sNo, cNo)

Student
sNo	sName	dNo
S01	James	D01
S02	Rocdy	D01
S03	Jackson	D02
S04	Jane	D01
S05	Milli	D02

Dept
dNo	dName
D01	CSE
D02	EEE

Course
cNo	cName	dNo
C11	DS	D01
C12	OS	D01
C21	DE	D02
C22	PT	D02
C23	CV	D03

Register
sNo	cNo
S01	C11
S01	C12
S02	C11
S03	C21
S03	C22
S03	C23
S04	C11
S04	C12
S05	C11
S05	C21

SELECT * FROM Student AS S WHERE NOT EXIST

(SELECT cNo FROM Course WHERE dNo = “D01”

SELECT cNo FROM Register WHERE sNo = S.sNo)

The number of rows returned by the above SQL query is___________.

Your Answer:

Go to Question:

Prev Question

Next Question