70-433 · Question #109
You have a table named Sales.SalesOrderHeader and a table named Person.Person. You are tasked to write a query that returns SalesOrderID and SalesPersonName that have an OrderDate greater than…
Sign in or unlock 70-433 to reveal the answer and full explanation for question #109. The question stem and answer options stay visible for context.
Question
You have a table named Sales.SalesOrderHeader and a table named Person.Person. You are tasked to write a query that returns SalesOrderID and SalesPersonName that have an OrderDate greater than 20040101. SalesPersonName should be made up by concatenating the columns named FirstName and LastName from the table named Person.Person. You need to write a query to return data, sorted in alphabetical order, by the concatenation of FirstName and LastName. Which Transact-SQL statement should you use?
Options
- ASELECT SalesOrderID, FirstName + ' ' + LastName as SalesPersonName
- BSELECT SalesOrderID, FirstName + ' ' + LastName as SalesPersonName
- CSELECT SalesOrderID, FirstName +' ' + LastName as SalesPersonName
- DSELECT SalesOrderID, FirstName + ' ' + LastName as SalesPersonName
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.