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