Consider the table Student (stuid, name, course, marks). Which one of the…

PYQ UGC NET 2013Modified — slightly modified from the official paper; see the solution

Consider the table Student (stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5 ? Q.1. Select S.stuid From student S Where not exists (select * from student e where e.course = ‘5’ and e.marks ≥ s.marks) Q.2. Select S.stuid From student S Where s.marks > any (select distinct marks from student S where s.course = 5)

  1. A.

    Q. 1

  2. B.

    Q. 2

  3. C.

    Both Q. 1 and Q. 2

  4. D.

    Neither Q. 1 nor Q. 2

Attempted by 33 students.

Sign up free to check your answer

Sign up free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…