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.
Answer Posted / karuna
option d
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Differentiate between a hyperlink control and a linkbutton control.
What are the different properties of server control that exists?
What do you mean by marshalbyref?
Explain the use of errorprovider control in .net?
How dataadapter.fill works?
What language does asp.net use?
When maintaining session through sql server, what is the impact of read and write operation on session objects?
Who generates session id?
What is the question mark in a url?
What is postback request?
What is the importance of aspnet_isapi.dll, inetinfo.exe andaspnet_wp.exe in the page loading process.
What is a uri query?
How long do session variables last?
Explain how cookies work.
How many types of file extensions for razor views in ASP.Net MVC?