Explanation:
: subquery can be use in the FROM clause of a SELECT statement, in the WHERE clause of a SELECT statement, in the SET clauses of an UPDATE statement, in the VALUES clause of an INSERT statement. Incorrect answer :
1: subquery cannot be used
3: subquery cannot be used
Reference:
Introduction to Oracle9i : SQL, Oracle University Study Guide, 6-5

---