Question

The operators that are used when a subquery returns multiple rows to be evaluated in comparison to the outer query are _____________

(a) IN and NOT IN

(b) EXISTS and NOT EXISTS

(c) OUTER JOIN and INNER JOIN

(d) LEFT JOIN and RIGHT JOIN

This question was posed to me in semester exam.

Asked question is from Maintaining Logs in portion General MySQL Administration of MySQL

Answer 1

Right answer 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.