Consider the relational schemas Student, Course and Enrollment: Student( SId , Name, Age, DOB, Phone_Number)\ Course( CId , CName, Credits)\ Enrollment( EId , SId, CId, Term) Now consider the following SQL query: SELECT S.Name FROM Student S WHERE NOT EXISTS ( SELECT FROM Course C WHERE NOT EXISTS ( SELECT FROM Enrollment E WHERE E.SId = S.SId AND E.CId = C.CId ) ) The query returns:

(C) Names of students who have enrolled in all available courses

(A) Names of students who have enrolled in at least one course

(B) Names of students who have enrolled in exactly one course

(D) Names of students who have not enrolled in any course

Database Management Systems · Quiz 1 · 13 Jul 2025 · May 2025 term

Question 5: Consider the relational schemas Student, Course and Enrol…

Question 5

+4 marksOne correct option

Consider the relational schemas Student, Course and Enrollment:

Student(SId, Name, Age, DOB, Phone_Number)
Course(CId, CName, Credits)
Enrollment(EId, SId, CId, Term)

Now consider the following SQL query:

sql

1SELECT S.Name
2FROM Student S
3WHERE NOT EXISTS (
4    SELECT *
5    FROM Course C
6    WHERE NOT EXISTS (
7        SELECT *
8        FROM Enrollment E
9        WHERE E.SId = S.SId
10          AND E.CId = C.CId
11    )
12)

The query returns:

A
Names of students who have enrolled in at least one course
B
Names of students who have enrolled in exactly one course
C
Names of students who have enrolled in all available courses
D
Names of students who have not enrolled in any course

Show answer

Correct answer

C
Names of students who have enrolled in all available courses

See the whole paper Take it as a mock test

Question 5 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 13 Jul 2025, in the May 2025 term (IIT M DIPLOMA AN EXAM QDD2 13 July 2025). It carries 4 marks.

Question 5: Consider the relational schemas Student, Course and Enrol…

Question 5

More questions from this paper