Multiple choice technology databases

What is the Result of the following 'AXA'||NULL||'US' ?

  1. Error

  2. NULL

  3. AXA US

  4. AXAUS
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Oracle SQL, the concatenation operator || treats NULL values as empty strings. Therefore, concatenating 'AXA', NULL, and 'US' results in the single concatenated string 'AXAUS'. In most other SQL dialects, concatenating with NULL yields NULL.

Keep practicing — related questions