Oracle Database 12c: SQL Fundamentals — Question 27

In which four clauses can a sub query be used? (Choose four.)

Answer options

• A. in the INTO clause of an INSERT statement
• B. in the FROM clause of a SELECT statement
• C. in the GROUP BY clause of a SELECT statement
• D. in the WHERE clause of a SELECT statement
• E. in the SET clause of an UPDATE statement
• F. in the VALUES clause of an INSERT statement

Correct answer: A, B, D, E

Explanation

The correct answers A, B, D, and E are valid locations for a subquery, allowing for dynamic data retrieval during INSERT and SELECT operations. Options C and F are incorrect because a subquery cannot be utilized in the GROUP BY clause or the VALUES clause of an INSERT statement.