Microsoft
70-457 · Question #29
You administer a Microsoft SQL Server database that supports a shopping application. You need to retrieve a list of customers who live in territories that do not have a sales person. Which…
The correct answer is B. SELECT CustomerID FROM Customer D. SELECT CustomerID FROM Customer. See the full explanation below for the reasoning.
Question
You administer a Microsoft SQL Server database that supports a shopping application. You need to retrieve a list of customers who live in territories that do not have a sales person. Which Transact-SQL query or queries should you use? (Each correct answer presents a complete solution. Choose all that apply.)
Options
- ASELECT CustomerID FROM Customer
- BSELECT CustomerID FROM Customer
- CSELECT CustomerID FROM Customer
- DSELECT CustomerID FROM Customer
How the community answered
(44 responses)- A16% (7)
- B73% (32)
- C11% (5)
Community Discussion
No community discussion yet for this question.