Test: Nested Subqueries in SQL - Computer Science Engineering (CSE) MCQ

SQL subqueries that can occur wherever a value is permitted provided the subquery gives only one tuple with a single attribute are called Scalar subqueries. Scalar Subqueries can be used in the SQL update statement when they are used under the set clause.

A correlated sub-query is the one that uses the correlation name of an outer query.

The all comparison checker is used to check “each and every” condition. The “each” and “every” comparison checkers do not exist in SQL.

A subquery is a select-from-where expression that is nested within another query. Common uses for sub-queries are to perform tests for set membership, make set comparisons etc.

The query gives the studentID with the maximum marks because the max(marks) aggregation gives the maximum of the marks.

The unique construct returns true if the argument in the sub-query is void of duplicates. The not null construct avoids the specification of null values into the attribute.

The exists construct returns true if a given tuple is present in the subquery. The not exists construct gives true if a given tuple is not present in the subquery.

The “some” comparison is used to check for at least one condition. The > symbol is used to test whether the marks are greater than the right hand side or not.

The in connective is used to test for the membership in a set, where the set is a collection of values given by the select clause.

SQL allows the use of Subqueries inside the from clause. The subquery used in the from clause must have in its result the attributes that are specified in the select clause.