Oracle
1Z0-061 · Question #160
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. Sub queries can contain GROUP BY and ORDER BY clauses D. Main query and sub query can get data from different tables. 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
- BSub queries can contain GROUP BY and ORDER BY clauses
- COnly one column or expression can be compared between the main query and subqeury
- DMain query and sub query can get data from different tables
- EMain query and sub query must get data from the same tables
- FSub queries can contain ORDER BY but not the GROUP BY clause
How the community answered
(64 responses)- A83% (53)
- C2% (1)
- E6% (4)
- F9% (6)
Community Discussion
No community discussion yet for this question.