Multiple choice technology databases

select '1'+'1' from dual ; The o/p would be..

  1. 2

  2. 1+1

  3. Error: invalid number

  4. Error: invalid Character

  5. Error: invalid identifier
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle, the '+' operator with strings causes implicit conversion to numbers. Both '1' strings are converted to numbers, then added. The result is 2 (numeric), not '11' (string concatenation would use ||). The implicit numeric conversion makes this a valid arithmetic operation.

Keep practicing — related questions