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

Question : 14 of 50

Marks: +1, -0

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

The ORDER BY Clause can be used in a subquery.
A subquery can be used in the FROM clause of a SELECT statement.
If a subquery returns NULL, the main query may still return rows.
A subquery can be placed in a WHERE clause, a GROUP BY clause, or a HAVING clause.
Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of a subquery.

Go to Question:

Prev Question

Next Question