Question

What is the result of the following query?

SELECT studname
FROM college
WHERE marks &gt; SOME (SELECT marks
                                        FROM student
                     WHERE SECTION = 'c');

a.

The query gives all the studnames for which marks are greater than all the students in section c

b.

The query gives all the studnames for which the marks are greater than at least on student in section c

c.

The query gives all the studnames for which the marks are less than all the students in section c

d.

The query is syntactically incorrect

Posted under SQL DBMS

Answer: (b).The query gives all the studnames for which the marks are greater than at least on student in section c

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. What is the result of the following query?

Add Comment

Similar Questions

Discover Related MCQs

Q. The ________ comparison checker is used to check “each and every” condition

View solution

Q. The ______ construct returns true if a given tuple is present in the subquery.

View solution

Q. What is a correlated sub-query?

View solution

Q. The _________ construct returns true if the argument in the sub-query is void of duplicates

View solution

Q. State true or false: We can use Subqueries inside the from clause

View solution

Q. SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called _________

View solution

Q. Insert the appropriate key word in the blank in the query ( A is a relation)
delete ______ A

where P < 5;

View solution

Q. How many relations can a delete command operate on?

View solution

Q. What is the format of entering date into a database while inserting data into it?

View solution

Q. To change a value in a tuple without changing all the values in the tuple, we use the _____ statement

View solution

Q. State true or false: We cannot write a where clause under an update command

View solution

Q. Scalar Subqueries can be used in the SQL update statement when they are used under the ____ clause

View solution

Q. Which of the following cannot be used to modify the data in a database

View solution

View All MCQs on SQL

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Data Structures and Algorithms

Journey through the fundamentals of Data Structures and Algorithms with our extensive...

Digital Image Processing (DIP)

Delve into the techniques of enhancing digital images with our Digital Image...