READ Free Dumps For Oracle- 1z1-051
| Question ID 4749 | Which two statements are true regarding single row functions? (Choose two.) |
| Option A | A. They can be nested only to two levels |
| Option B | B. They always return a single result row for every row of a queried table |
| Option C | C. Arguments can only be column values or constant |
| Option D | D. They can return a data type value different from the one that is reference |
| Option E | E. They accept only a single argument |
| Correct Answer | B,D |
| Question ID 4750 | Which statement is true regarding the UNION operator? |
| Option A | A. The number of columns selected in all SELECT statements need to be the same |
| Option B | B. Names of all columns must be identical across all SELECT statements |
| Option C | C. By default, the output is not sorted |
| Option D | D. NULL values are not ignored during duplicate checking |
| Correct Answer | D |