What does the following SQL statement return, assuming that all tables and colu

What does the following SQL statement return, assuming that
all tables and column names are correct?
SELECT FirstName, StreetAddress
FROM Employees
JOIN AddressBook
ON Employees.EmpID = AddressBook.EmpID

a) Nothing, the JOIN syntax is wrong.
b) All the records form the Employees table, and only the
matching ones form the StreetAddress table.
c) All the records from the StreetAddress table and only the
matching records form the Employees table.
d) Only the matching records from the two tables.

Question Posted / raghava

4 Answers
9315 Views
Syntax Softtech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What does the following SQL statement return, assuming that all tables and column names are correct..

Answer / karuna

option d

Is This Answer Correct ?

2 Yes

1 No

What does the following SQL statement return, assuming that all tables and column names are correct..

Answer / shikhar

I think the state ment above should return the records from
matching records from two talbes since the JOIN state ment
specifies the middle element..i.e employee...let us see how
it works..
lets say we hav two elemt rows( here i am taking the only
one column from each table since it would provide us with
the required understanding....)

employees addressbook
---------- ------------
EMP_NAME EMP_NAME
-------- -----------
ram raju
raj harish
ravi hani
rohit jitender
raju fina
manish kittu

now when these two statements are joined ,first of all the
first state ment is scanned and its first element i.e 'ram'
is matched againest the all the element of thhe other list
i.e addressbook...if it finds the name 'ram' in addressbook
it will select it as a part of the result otherwise it just
looks move on to another one thats 'raj'...n one important
thing ... in case 'ram' finds the match in the addressbook
twice...it will not take bothe of them .....it will skip
all the others and move on to the next row....

Is This Answer Correct ?

0 Yes

0 No

What does the following SQL statement return, assuming that all tables and column names are correct..

Answer / vivek

simply ans : D

becoz single JOIN means "inner join" which return common
record

Is This Answer Correct ?

1 Yes

1 No

What does the following SQL statement return, assuming that all tables and column names are correct..

Answer / ar prabhakaran

d) Only the matching records from the two tables.

JOIN will return only matching column values from both tables.

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More ASP.NET Interview Questions

How many types of cache are there?

0 Answers

What is a DLL Hell Problem in .Net?

12 Answers

Caching techniques in .NET ?

1 Answers Microsoft,

What is cookieless session id explain in brief?

0 Answers

if i have placed the button control with the OnClick event like <asp:Button ID="mybutton" runat="server" Text="Insert" onclick="mybutton_Click" /> and some other controls(buttons, textboxes) in .aspx page. When i run the page, the button displays in the page source of the browser like <input type="submit" name="mybutton" value="Insert" id="mybutton" /> here, it does not display the onclick event, then how the page calls the button click on the server side, how the server side identify which button cause the submit, and how this page moves to the server side.

1 Answers

What's a bubbled event?

3 Answers Siebel,

how to convert from sql2000 numeric to int in asp.net with sqlparameter?

1 Answers

What is dataset ?

18 Answers Infosys, Kuwait University,

Suppose you want an asp.net function (client side) executed on the mouseover event of a button. Where do you add an event handler?

0 Answers

what is use to destroy an object? illustrate.

2 Answers Patni,

what is the challenging situation you faced in your career?

3 Answers Calsoft, HP, Satyam, Wipro,

What are the steps to follow to host a web application on a web server?

0 Answers MCN Solutions,

For more ASP.NET Interview Questions Click Here