Multiple choice technology databases

The result of concatenating two character strings is always a VARCHAR2 character string.

  1. True

  2. False

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

The concatenation result depends on input types. If concatenating two CHAR values, Oracle returns CHAR. For VARCHAR2 inputs, it returns VARCHAR2. The statement incorrectly claims VARCHAR2 is always returned.