Oracle
1Z0-061 · Question #85
Which three statements are true regarding sub queries? (Choose three.)
The correct answer is A. Multiple columns or expressions can be compared between the main query and sub query B. Main query and sub query can get data from different tables C. Sub queries can contain GROUP BY and ORDER BY clauses. See the full explanation below for the reasoning.
Question
Which three statements are true regarding sub queries? (Choose three.)
Options
- AMultiple columns or expressions can be compared between the main query and sub query
- BMain query and sub query can get data from different tables
- CSub queries can contain GROUP BY and ORDER BY clauses
- DMain query and sub query must get data from the same tables
- ESub queries can contain ORDER BY but not the GROUP BY clause
- FOnly one column or expression can be compared between the main query and subqeury
How the community answered
(46 responses)- A83% (38)
- D2% (1)
- E7% (3)
- F9% (4)
Community Discussion
No community discussion yet for this question.