Which operator can be used with a multiple-row subquery?

The correct answer is D. NOT IN. Only NOT IN operator can be used with a multi-row sub-query. All others may be used with single-row sub-query only. Incorrect Answers A: When sub-queries are linked to the parent by equality comparisons, the parent query expects only one row of data from the sub-query, so "="…

Displaying Data from Multiple Tables and Subqueries

Question

Options

A=
BLIKE
CBETWEEN
DNOT IN
EIS
F<>

How the community answered

(58 responses)

A
3% (2)
B
2% (1)
C
5% (3)
D
78% (45)
E
12% (7)

Explanation

Only NOT IN operator can be used with a multi-row sub-query. All others may be used with single-row sub-query only. Incorrect Answers A: When sub-queries are linked to the parent by equality comparisons, the parent query expects only one row of data from the sub-query, so "=" operator cannot be used with a multiple-row sub- B: Operator LIKE will work only with single-row sub-queries. C: Operator BETWEEN will not work with a multi-row sub-queries. E: Operator LIKE is used only for single-row sub-queries. F: When sub-queries are linked to the parent by equality comparisons, the parent query expects only one row of data from the sub-query, so "<>" operator cannot be used with a multiple-row

Topics

#multiple-row subquery#NOT IN operator#subquery operators#IN ANY ALL

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice