Multiple choice technology programming languages

How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;

  1. 0

  2. 1

  3. 3

  4. 2
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SELECT concatenates three fields into a single expression and assigns it the alias "Adress". This yields one column in the result set. Options claiming 0, 2, or 3 columns are wrong because the concatenation produces exactly one output column.

Keep practicing — related questions