Oracle
1Z0-071 · Question #51
1Z0-071 Question #51: Real Exam Question with Answer & Explanation
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. 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
Community Discussion
No community discussion yet for this question.