Oracle Database SQL 12c 1z0-071 Exam Practice Test 1

Question : 18 of 50

Marks: +1, -0

Which three statements are true regarding subqueries? (Choose three.)

Multiple columns or expressions can be compared between the main query and subquery.
Subqueries can contain ORDER BY but not the GROUP BY clause.
Main query and subquery can get data from different tables.
Subqueries can contain GROUP BY and ORDER BY clauses.
Main query and subquery must get data from the same tables.
Only one column or expression can be compared between the main query and subquery.

Go to Question:

Prev Question

Next Question