Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 9171 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
Is viewstate enabled by default?
Differentiate between Server.Transfer and Response.Redirect with functionality? Why we can choose one over the other?
What is the life cycle of web page?
What is the use of ASP.NET routing?
What is the biggest disadvantage of “Other Return Types” in Web API?
How do we ensure view state has not tampered?
Explain the use of view state?
Can we make activex dll also ti execute in some process as that of client ? How can we do?
What are web server controls in asp.net?
Explain http handlers? Where we can use the http handlers?
What is query string with example?
What is form submit?
What is use of Master Page in ASP.NET web pages?
What is mta?
What is postback pixel?
