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
(a) IN and NOT IN
(b) EXISTS and NOT EXISTS
(c) OUTER JOIN and INNER JOIN
(d) LEFT JOIN and RIGHT JOIN
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.