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
Medical
NEETAIIMS
Graduate Aptitude Test in Engineering
GATE CSEGATE ECEGATE EEGATE MEGATE CEGATE PIGATE IN
Civil Services
UPSC Civil Service
Defence
NDA
Staff Selection Commission
SSC CGL Tier I
CBSE
Class 12