Multiple choice technology databases

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

  1. 3

  2. 4

  3. 1

  4. None
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The SQL query uses concatenation (||) to combine address1, a comma, address2, another comma, and address2 again into a single column with alias 'Adress'. Regardless of how many source columns are concatenated, the result set contains exactly one column named 'Adress'.

Keep practicing — related questions