Microsoft
70-433 · Question #129
You have two tables named dbo.CurrentProducts and dbo.ArchiveProducts. You have the following query: SELECT ProductID, Name FROM dbo.CurrentProducts UNION ALL SELECT ProductID, Name FROM…
The correct answer is D. Products that appear in dbo.CurrentProducts or dbo.ArchiveProducts. See the full explanation below for the reasoning.
Question
You have two tables named dbo.CurrentProducts and dbo.ArchiveProducts. You have the following query:
SELECT ProductID, Name FROM dbo.CurrentProducts UNION ALL SELECT ProductID, Name FROM dbo.ArchiveProducts; You need to predict the list of products that the query will produce. Which list of products should the query return?
Options
- AProducts that appear in dbo.CurrentProducts or dbo.ArchiveProducts but not in both.
- BProducts that have a matching ProductID and Name in dbo.CurrentProducts or
- CProducts that appear in dbo.CurrentProducts or dbo.ArchiveProducts.
- DProducts that appear in dbo.CurrentProducts or dbo.ArchiveProducts.
How the community answered
(20 responses)- A5% (1)
- B5% (1)
- C20% (4)
- D70% (14)
Community Discussion
No community discussion yet for this question.