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
- 7732 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
Answer Posted / karuna
option d
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
When maintaining session through sql server, what is the impact of read and write operation on session objects?
Define the types of configuration files.
What is routing in MVC?
What is http response header?
How many types of Cookies are available in ASP.NET?
What is the difference between union and structure?
What can we do with asp.net?
what are the events raised in asp.net page life cycle?in which stage view state can be loaded?
Why do we need a web application session?
Is asp.net free?
Can the validation occurs in server-side or client-side? If the validation occurs why should we do?
What are the Difference between asp.net and asp ?
Differentiate between file-based dependency and key-based dependency.
What are uri parameters?
What is preprocessor in .net and type, where it use?
