GATE Computer Science (CS) 2022 Shift 1 Solved Paper
© examsiri.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)
SQL Query:
SELECT * FROM Student AS S WHERE NOT EXIST
(SELECT cNo FROM Course WHERE dNo = “D01”
EXCEPT
SELECT cNo FROM Register WHERE sNo = S.sNo)
The number of rows returned by the above SQL query is___________.
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 |
SQL Query:
SELECT * FROM Student AS S WHERE NOT EXIST
(SELECT cNo FROM Course WHERE dNo = “D01”
EXCEPT
SELECT cNo FROM Register WHERE sNo = S.sNo)
The number of rows returned by the above SQL query is___________.
- Your Answer:
Go to Question: