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 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 DBMS

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!

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

SQL Server

Master Microsoft's database server with our SQL Server MCQs. Topics cover database...

Systems Analysis and Design Methods

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

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Artificial Intelligence

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

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...