How many columns are retrieved from this query:SELECT address1 || ',' ||address2 ||',' ||address2 "Address" FROM = employee;A. 3B. 2C. 1D. 0

This question is related to Oracle Interview

Interview Candidate
Jun 19th, 2005
6
7205

Showing Answers 1 - 6 of 6 Answers

ashok shroff

Sep 16th, 2005

B.2

sam

Apr 25th, 2006

SQL>SELECT address1||','||address2||','||address2 " Address" FROM employee;ADDRESS-----------------------------------------------------------------------------------------------XXXXXXX,XXXXXXXX,XXXXXXXXXX----------------so answer is -----> C.1

Jim Abraham

May 27th, 2006

All the addressed rows in the select statement are concatenated and renamed as "Addresss". So only 1 column will be reflected in the result.
So answer is C

JohnCenzer
Profile Answers by JohnCenzer

Nov 30th, 2006

I think there is some confusion between "retrieve" and "return".
The query retreives 2 columns from the table - address1 and address2,
and returns 1 column "Address"