Q44

MSQ2 marks

Consider the following relational schema: Students ( $\underline{\text{rollno: integer}},$ name: string, age: integer, cgpa: real) Courses ( $\underline{\text{courseno: integer}},$ cname: string, credits: integer) Enrolled ( $\underline{\text{rollno: integer}},$ $\underline{\text{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)

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

(B)

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

(C)

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

(D)

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

Loading…