Question

Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

(a) IN and NOT IN

(b) EXISTS and NOT EXISTS

(c) OUTER JOIN and INNER JOIN

(d) LEFT JOIN and RIGHT JOIN

I had been asked this question during an interview.

I would like to ask this question from Performing Multiple topic in chapter Using SQL to Manage Data of MySQL

Answer 1

Correct option is (a) IN and NOT IN

The best explanation: When there is a need to evaluate multiple rows in comparison to the outer query, the ‘IN’ and ‘NOT IN’ operators are used. They are used for testing whether a comparison value is present in a set of values.