Home » Oracle » 1z0-051 » Which four clauses can a sub query be used?
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
Correct Answer: ABDE
Explanation/Reference:
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,
E: a sub query can be used in the SET clauses of an UPDATE statement,
Incorrect answer:
Csub query cannot be used
F: is incorrect.
Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 6-5
Download Printable PDF. VALID exam to help you PASS.
|
|