Consider the relational database with the following four schemas and their respective instances. $\text{Student}(\underline{\text{sNo}}, \text{sName}, \text{dNo})\quad \text{Dept}(\underline{\text{dNo}}, \text{dName})$ $\text{Course}(\underline{\text{cNo}}, \text{cName}, \text{dNo})\quad \text{Register}(\underline{\text{sNo}}, \underline{\text{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 ________.

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 …

Topic-wise GATE CS PYQs with verified steps