nerdexam
Microsoft

70-457 · Question #32

You administer a Microsoft SQL Server database that supports a banking transaction management application. You need to retrieve a list of account holders who live in cities that do not have a branch…

The correct answer is A. SELECT AccountHolderID B. SELECT AccountHolderID. See the full explanation below for the reasoning.

Question

You administer a Microsoft SQL Server database that supports a banking transaction management application. You need to retrieve a list of account holders who live in cities that do not have a branch location. Which Transact-SQL query or queries should you use? (Each correct answer presents a complete solution. Choose all that apply.)

Options

  • ASELECT AccountHolderID
  • BSELECT AccountHolderID
  • CSELECT AccountHolderlD
  • DSELECT AccountHolderID

How the community answered

(35 responses)
  • A
    83% (29)
  • C
    11% (4)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 70-457 Practice