Exam4Training

Which Transact-SQL query or queries should you use?

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.)
A . SELECT AccountHolderID
FROM AccountHolder
WHERE CityID NOT IN (SELECT CityID FROM BranchMaster)

B . SELECT AccountHolderID
FROM AccountHolder
WHERE CityID <> ALL (SELECT CityID FROM BranchMaster)

C . SELECT AccountHolderID
FROM AccountHolder
WHERE CityID <> SOME (SELECT CityID FROM BranchMaster)
D . SELECT AccountHolderID
FROM AccountHolder
WHERE CityID <> ANY (SELECT CityID FROM BranchMaster)

Answer: A, B

Explanation:

Verified the answers as correct.

Reference: http://msdn.microsoft.com/en-us/library/ms188047.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms177682.aspx

Reference: http://msdn.microsoft.com/en-us/library/ms173545.aspx

Latest 70-461 Dumps Valid Version with 232 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version