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 SQL string concatenation using the || operator, NULL is treated as an empty string, not as a null terminator. Therefore 'AXA' + empty string + 'US' = 'AXAUS'. This is standard SQL behavior where NULL in string concatenation acts like ''.

Keep practicing — related questions