READ Free Dumps For Oracle- 1z1-051
Question ID 4922 | In which four clauses can a sub query be used? (Choose four.) |
Option A | A. in the INTO clause of an INSERT statement |
Option B | B. in the FROM clause of a SELECT statement |
Option C | C. in the GROUP BY clause of a SELECT statement |
Option D | D. in the WHERE clause of a SELECT statement |
Option E | E. in the SET clause of an UPDATE statement |
Option F | F. in the VALUES clause of an INSERT statement |
Correct Answer | A,B,D,E |
Question ID 4923 | Examine this statement: |
Option A | A. An error is returned. |
Option B | B. You are prompted to enter a new value. |
Option C | C. A report is produced that matches the first report produced. |
Option D | D. You are asked whether you want a new value or if you want to run the report based on the previous value. |
Correct Answer | C |