Oracle
1Z0-061 · Question #200
Which three statements are true about multiple-row sub queries? (Choose three.)
The correct answer is A. They can contain a subquery within a sub query. B. They can return multiple columns as well as rows. E. They can contain group functions and GROUP BY and HAVING clauses. See the full explanation below for the reasoning.
Question
Which three statements are true about multiple-row sub queries? (Choose three.)
Options
- AThey can contain a subquery within a sub query.
- BThey can return multiple columns as well as rows.
- CThey cannot contain a sub query within a sub query.
- DThey can return only one column but multiple rows.
- EThey can contain group functions and GROUP BY and HAVING clauses.
- FThey can contain group functions and the GROUP BY clause, but not the HAVING clause.
How the community answered
(29 responses)- A83% (24)
- C10% (3)
- D3% (1)
- F3% (1)
Community Discussion
No community discussion yet for this question.