READ Free Dumps For Oracle- 1z0-020
| Question ID 8249 | Which type of statement specifies whose schema should be used when resolving object names? |
| Option A | DEFINE |
| Option B | AUTHID |
| Option C | PRAGMA |
| Option D | EXECUTE |
| Option E | SET USER |
| Correct Answer | B |
| Question ID 8250 | Examine this statement: SELECT * FROM (SELECT class_id, crs_id FROM classes ORDER BY start_date DESC) WHERE ROWNUM < 11; What will happen when this executes? |
| Option A | The ten rows with the latest start date will be returned. |
| Option B | The ten rows with the earliest start date will be returned. |
| Option C | An error is returned citing an ORDER BY embedded within a subquery. |
| Option D | An error is returned citing an ORDER BY clause reference to a column that is not selected. |
| Correct Answer | A |