Microsoft
70-432 · Question #220
70-432 Question #220: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #220. The question stem and answer options stay visible for context.
Question
You administer a Microsoft SQL Server 2008 R2 instance that contains two databases named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the SQL_Latin1_General_CP1_CS_AS collation. You need to write a query that returns all customers having the same name in each database. You also need to ensure that the query is not case-sensitive. Which Transact-SQL query should you use?
Exhibit
Options
- AOption A
- BOption B
- COption C
- DOption D
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 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.