simply ans : D becoz single JOIN means "inner join" which ret

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 / vivek

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

Answer Posted / vivek

simply ans : D

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

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain page output caching?

949

Differentiate between early binding and late binding.

1047

What is repository pattern in mvc.net? : asp.net mvc

961

What is the difference between client-side and server-side validations in webpages?

972

How many ways are there to maintain a state in .net? What is view state?

979

What is the flow of processing of the request? : asp.net mvc

994

What are the validation controls available in ASP.NET?

973

How can we Validate a Controls in ASP.NET page using JavaScript?

1126

What is state management in asp.net with example?

912

What are the advantages and limitations of query string?

1019

If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?

956

Where the assembly is stored in asp.net?

977

What is asp.net caching?

984

Explain the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc

946

How do you design a website with multilingual support in ASP.NET ?

945