Multiple choice technology databases

5 + NULL evaluates to 5 and ‘PL/’ || NULL || ‘SQL’ evaluates to ‘PL/SQL’

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle SQL/PL/SQL, adding NULL to a number yields NULL (5 + NULL is NULL, not 5), whereas concatenating NULL with a string ignores the NULL ('PL/' || NULL || 'SQL' evaluates to 'PL/SQL'). Since the first expression evaluates to NULL, the statement is false.