1
GATE CSE 2025 Set 2
MCQ (More than One Correct Answer)
+2
-0

Consider the following relational schema:

Students ($$\mathrm{\underline {rollno:integer}}$$, name: string, age: integer, cgpa: real)

Courses ($$\mathrm{\underline {courseno:integer}}$$, cname: string, credits: integer)

Enrolled ($$\mathrm{\underline {rollno:integer}}$$, $$\mathrm{\underline {courseno:integer}}$$, grade: string)

Which of the following options is/are correct SQL query/queries to retrieve the names of the students enrolled in course number (i.e., courseno) $1470 ?$

A
GATE CSE 2025 Set 2 Database Management System - Structured Query Language Question 1 English Option 1
B
GATE CSE 2025 Set 2 Database Management System - Structured Query Language Question 1 English Option 2
C
GATE CSE 2025 Set 2 Database Management System - Structured Query Language Question 1 English Option 3
D
GATE CSE 2025 Set 2 Database Management System - Structured Query Language Question 1 English Option 4
2
GATE CSE 2025 Set 1
Numerical
+2
-0

Consider the following database tables of a sports league.

player(pid, pname, age)

team(tid, tname, city, cid)

coach(cid, cname)

members(pid, tid)

An instance of the table and an SQL query are given.

GATE CSE 2025 Set 1 Database Management System - Structured Query Language Question 2 English

The value returned by the given SQL query is ________ . (Answer in integer)

Your input ____
3
GATE CSE 2023
Numerical
+2
-0

Consider the following table named Student in a relational database. The primary key of this table is rollNum.

Student

rollNum name gender marks
1 Naman M 62
2 Aliya F 70
3 Aliya F 80
4 James M 82
5 Swati F 65

The SQL query below is executed on this database.

SELECT *

FROM Student

WHERE gender = 'F' AND

marks > 65;

The number of rows returned by the query is _____________.

Your input ____
4
GATE CSE 2022
Numerical
+2
-0

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

Student( $$\underline {sNo} $$ , sName, dNo) Dept( $$\underline {dNo} $$ , dName)

Course( $$\underline {cNo} $$ , cName, dNo) Register( $$\underline {sNo} $$ , $$\underline {cNo} $$ )

GATE CSE 2022 Database Management System - Structured Query Language Question 4 English

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 input ____
GATE CSE Subjects
Software Engineering
Web Technologies
EXAM MAP