READ Free Dumps For Oracle- 1z0-001
| Question ID 1550 | Which statement about using a subquery in the FROM clause is true? |
| Option A | A. You define a data source for future SELECT statements when using a subquery in the FROM clause. |
| Option B | B. You eliminate the need to create a new view or table by placing a subquery in the FROM clause. |
| Option C | C. You eliminate the need to grant SELECT privileges on the table used in the FROM clause subquery. |
| Option D | D. You cannot use a subquery in the FROM clause. |
| Correct Answer | B |
| Question ID 1551 | In which order does the Oracle Server evaluate clauses? |
| Option A | A. WHERE, GROUP BY, HAVING |
| Option B | B. WHERE, HAVING, GROUP BY |
| Option C | C. HAVING, WHERE, GROUP BY |
| Option D | D. GROUP BY, HAVING, WHERE |
| Correct Answer | A |