nerdexam
Microsoft

70-457 · Question #29

70-457 Question #29: Real Exam Question with Answer & Explanation

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

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice