ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

105 / 120

Question 105:

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

Answer options:

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