In which four clauses can a sub query be used? (Choose four.)
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
Explanation:
A: a sub query is valid on the INTO clause of an ISERT Statement
B: a sub query can be used in the FROM clause of a SELECT statement
D: a sub query can be used in the WHERE clause of a SELECT statement,
E: a sub query can be used in the SET clauses of an UPDATE statement,
Incorrect answer:
C:
sub query cannot be used
F: is incorrect.
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 6-5