Technical - How many columns are retrieved from this query:SELECT address1||','||address2||','||address2 "A

GeekInterview.com > Placement Papers > Oracle > Technical

Go To First | Previous Question | Next Question

Technical | Question 49 of 126

How many columns are retrieved from this query:
SELECT address1||','||address2||','||address2 "Address" FROM employee;

A. 1
B. 2
C. 3
D. 0

Total Answers and Comments: 11

Last Update: August 26, 2008

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

Last »

August 25, 2005 22:28:59

eussusn

RE: How many columns are retrieved from this query:SELECT address1||','||address2||','||address2 "A...

Is this answer useful? Yes | No

November 22, 2005 06:30:11

Milan

RE: How many columns are retrieved from this query:

Only one i.e. Address.

Is this answer useful? Yes | No

February 06, 2006 05:21:17

vadivel

RE: How many columns are retrieved from this query:

2 columns

address 1 and address2 columns

Is this answer useful? Yes | No

April 01, 2006 05:24:57

vipin

RE: How many columns are retrieved from this query:

Only one column

Is this answer useful? Yes | No

April 06, 2006 05:37:03

pramod kumar

RE: How many columns are retrieved from this query:

dont belive anybody.......its only ONE COLUMN ADDRESS

Is this answer useful? Yes | No

May 06, 2006 18:35:12

shynesh

RE: How many columns are retrieved from this query:

I think it is a simple question

Is this answer useful? Yes | No

July 24, 2006 06:52:31

saurabh

RE: How many columns are retrieved from this query:

Only One Column having full addres(i.e add1+add2+add3)

Is this answer useful? Yes | No

August 18, 2006 07:45:23

prasannasoni

Member Since: August 2006 Contribution: 1

RE: How many columns are retrieved from this query:

only one column of name Address Which contains Records like

address1 Address2 Address2

And So On

------------------

Is this answer useful? Yes | No

July 26, 2008 03:11:47

vijay_agg

Member Since: July 2008 Contribution: 1

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

Only one column will be retrieved with name Address having data from address1 address2 and address2

Is this answer useful? Yes | No

August 20, 2008 01:54:28

#10

rajivgupta780184

Member Since: August 2008 Contribution: 32

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

aNS>IS "C" I.E 3 COLUMN WILL BE RETRIVED FROM THIS QUERY BUT THEY ALL ARE CONCATENED BY A COMMA SEPERATED VALUE BY AN ALIAS "ADDRESS"
FROM THE EMPLOYEE TABLE.

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank