What is true regarding sub queries?

The correct answer is D. The inner query returns a value to the outer query. The inner query returns a value to the outer query. If the inner query does not return a value, the outer query does not return a result

Using Subqueries to Solve Queries

Question

Options

AThe inner query always sorts the results of the outer query
BThe outer query always sorts the results of the inner query
CThe outer query must return a value to the outer query
DThe inner query returns a value to the outer query
EThe inner query must always return a value or the outer query will give an error

How the community answered

(42 responses)

A
2% (1)
B
14% (6)
C
2% (1)
D
74% (31)
E
7% (3)

Explanation

The inner query returns a value to the outer query. If the inner query does not return a value, the outer query does not return a result

Topics

#subquery#inner query#outer query#return value

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice