Multiple choice

How many columns are presented after executing the given query? SELECT address1||','||address2||','||address2 Adress FROM employee;

  1. 0

  2. 1

  3. 2

  4. 3

  5. 4

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

The concatenation operator (||) combines multiple column values into a single expression. The query concatenates address1, address2, and address3 (note: address2 appears twice in the statement) into one column aliased as 'Adress'. Despite concatenating 3 source columns, the result is a single output column.

Keep practicing — related questions