READ Free Dumps For Oracle- 1z1-051
| Question ID 4924 | Which SQL statement returns a numeric value? |
| Option A | A. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP; |
| Option B | B. SELECT ROUND(hire_date) FROM EMP; |
| Option C | C. SELECT sysdate-hire_date FROM EMP; |
| Option D | D. SELECT TO_NUMBER(hire_date + 7) FROM EMP; |
| Correct Answer | C |
| Question ID 4925 | What are two reasons to create synonyms? (Choose two.) |
| Option A | A. You have too many tables. |
| Option B | B. Your tables names are too long. |
| Option C | C. Your tables have difficult names. |
| Option D | D. You want to work on your own tables. |
| Option E | E. You want to use another schema's tables. |
| Option F | F. You have too many columns in your tables. |
| Correct Answer | B,C |