Consider the following relational schema: Students (rollno: integer, name:…

GATE · 2025 · CS · Set 2 · Computer Science & IT

Consider the following relational schema:

Students (rollno: integer, name: string, age: integer, cgpa: real)

Courses (courseno: integer, cname: string, credits: integer)

Enrolled (rollno: integer, 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?

  1. A.

    SELECT S.name
    FROM Students S
    WHERE EXISTS (SELECT * FROM Enrolled E
                                  WHERE E.courseno = 1470
                                                        AND E.rollno = S.rollno);

  2. B.

    SELECT S.name
    FROM Students S
    WHERE SIZEOF (SELECT * FROM Enrolled E
                                  WHERE E.courseno = 1470
                                            AND E.rollno = S.rollno) > 0;

  3. C.

    SELECT S.name
    FROM Students S
    WHERE 0 < (SELECT COUNT(*)
                          FROM Enrolled E
                          WHERE E.courseno = 1470
                                                AND E.rollno = S.rollno);

  4. D.

    SELECT S.name
    FROM Students S NATURAL JOIN Enrolled E
    WHERE E.courseno = 1470;

Attempted by 156 students.

Sign up free to check your answer

Sign up free

Explore the full course: Gate Guidance By Sanchit Sir

Loading lesson…