READ Free Dumps For Oracle- 1z1-051
| Question ID 4822 | Which three task can be performed using SQL functions built into Oracle Database? (Choose three.) |
| Option A | A. Combining more than two columns or expressions into a single column in the output |
| Option B | B. Displaying a date in a non default format |
| Option C | C. Substituting a character string in a text expression with a specified string |
| Option D | D. Finding the number of characters in an expression |
| Correct Answer | B,C,D |
| Question ID 4823 | 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 accept only a single argument |
| Option C | C. They always return a single result row for every row of a queried table |
| Option D | D. They can return a data type value different from the one that is reference |
| Option E | E. Arguments can only be column values or constant |
| Correct Answer | C,D |