Oracle
1Z0-061 · Question #41
Evaluate the following SQL statement: Which statement is true regarding the above query if one of the values generated by the subquery is null?
The correct answer is D. It ignores the null value and generates output for the other values produced by the subquery. See the full explanation below for the reasoning.
Question
Evaluate the following SQL statement:
Which statement is true regarding the above query if one of the values generated by the subquery is null?
Exhibit
Options
- AIt produces an error.
- BIt executes but returns no rows.
- CIt generates output for null as well as the other values produced by the subquery.
- DIt ignores the null value and generates output for the other values produced by the subquery.
How the community answered
(48 responses)- A2% (1)
- B13% (6)
- C4% (2)
- D81% (39)
Community Discussion
No community discussion yet for this question.