🎴 Flashcard Mode
Database Performance & PL/SQL Fundamentals
Card1 / 20
Mastered0
Review0
QuestionClick to flip
How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
AnswerClick to flip back
A
1
💡 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'.