READ Free Dumps For Oracle- 1z0-061
| Question ID 2329 | Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null?
|
| Option A | A. Option A |
| Option B | B. Option B |
| Option C | C. Option C |
| Option D | D. Option D |
| Correct Answer | A |
| Question ID 2330 | Which two statements are true regarding single row functions? |
| Option A | A. MOD: returns the quotient of a division |
| Option B | B. TRUNC: can be used with number and date values |
| Option C | C. CONCAT: can be used to combine any number of values |
| Option D | D. SYSDATE: returns the database server current date and time |
| Option E | E. INSTR: can be used to find only the first occurrence of a character in a string |
| Option F | F. TRIM: can be used to remove all the occurrences of a character from a string |
| Correct Answer | B,D |