Oracle
1Z0-047 · Question #205
Which two statements are true regarding multiple-row subqueries? (Choose two.)
The correct answer is A. They can contain group functions. E. They should not be used with the NOT IN operator in the main query if NULL is likely to be a part of. See the full explanation below for the reasoning.
Question
Which two statements are true regarding multiple-row subqueries? (Choose two.)
Options
- AThey can contain group functions.
- BThey always contain a subquery within a subquery.
- CThey use the < ALL operator to imply less than the maximum.
- DThey can be used to retrieve multiple rows from a single table only.
- EThey should not be used with the NOT IN operator in the main query if NULL is likely to be a part of
How the community answered
(48 responses)- A83% (40)
- B8% (4)
- C6% (3)
- D2% (1)
Community Discussion
No community discussion yet for this question.