This topic contains 0 replies, has 0 voices, and was last updated by  EduGorilla 1 year, 11 months ago.

  • Author
    Posts
  • #1440541 Reply
     EduGorilla 
    Keymaster
    Select Question Language :


    Consider the following relations:
    Student (snum: integer, sname: string, major: string, level: string, age: integer)
    Class (name: string, meets at: string, room: string, fid: integer)
    Enrolled (snum: integer, cname: string)
    Faculty (fid: integer, fname: string, deptid: integer)
    Consider the following SQL statements:
    SELECT DISTINCT S.sname
    FROM Student S
    WHERE S.snum IN
    (SELECT E.snum
    FROM Enrolled E
    GROUP BY E.snum
    HAVING COUNT (*) >= ALL (SELECT COUNT (*)
    FROM Enrolled E2
    GROUP BY E2.snum))
    What is the output of the following Query?

    Options :-

    1. Name of all the students who are enrolled in every course.
    2. Name of all the students who are enrolled in some course.
    3. Name of all the students who are enrolled in maximum no of course.
    4. None of these.
    Post your Training /Course Enquiry
    Are You looking institutes / coaching center for
    • IIT-JEE, NEET, CAT
    • Bank PO, SSC, Railways
    • Study Abroad
    Select your Training / Study category
Reply To: Consider the following relations: Student (snum: integer, sname: string, major: string, level: strin….
Your information:




Verify Yourself




Log in with your credentials

or    

Forgot your details?

Create Account