READ Free Dumps For Oracle- 1z0-007
| Question ID 8049 | What is true regarding subqueries? |
| Option A | The inner query always sorts the results of the outer query |
| Option B | The outer query always sorts the results of the inner query |
| Option C | The outer query must return a value to the outer query |
| Option D | The inner query returns a value to the outer query |
| Option E | The inner query must always return a value or the outer query will give an error |
| Correct Answer | D |
| Question ID 8050 | For which action can you use the TO_DATE function? |
| Option A | Convert any date literal to a date |
| Option B | Convert any numeric literal to a date |
| Option C | Convert any character literal to a date |
| Option D | Convert any date to a character literal |
| Option E | Format '10-JAN-99' to 'January 10 1999' |
| Correct Answer | C |