What is the result of the following query?
Posted: Thu Jul 14, 2022 8:53 am
SELECT studentdatabasename
FROM RDBMS
WHERE marks > SOME (SELECT marks
FROM student
WHERE SECTION = 'c');
a) The query gives all the studentdatabasename for which marks are greater than all the students in section c
b) The query gives all the studentdatabasename for which the marks are greater than at least on student in section c
c) The query gives all the studentdatabasename for which the marks are less than all the students in section c
d) The query is syntactically incorrect
FROM RDBMS
WHERE marks > SOME (SELECT marks
FROM student
WHERE SECTION = 'c');
a) The query gives all the studentdatabasename for which marks are greater than all the students in section c
b) The query gives all the studentdatabasename for which the marks are greater than at least on student in section c
c) The query gives all the studentdatabasename for which the marks are less than all the students in section c
d) The query is syntactically incorrect