The special operator used to check whether a subquery returns any rows is _____.
A) BETWEEN
B) EXISTS
C) LIKE
D) IN

Question

Quizplus · Accepted Answer

The EXISTS operator is used to check whether a subquery returns any rows. It is often used in conjunction with a correlated subquery to check for the existence of a related record in another table. The BETWEEN operator is used to check if a value falls within a specified range, the LIKE operator is used for pattern matching in strings, and the IN operator is used to check if a value matches any value in a list or subquery.

The Special Operator Used to Check Whether a Subquery Returns