Microsoft
70-433 · Question #149
Your database contains Products and Orders tables. You need to write a query which return ProductID of the products which have not been placed in any order. Which operator can you use?
The correct answer is D. Exclude. See the full explanation below for the reasoning.
Question
Your database contains Products and Orders tables. You need to write a query which return ProductID of the products which have not been placed in any order. Which operator can you use?
Options
- AUnion
- BUnion ALL
- CIntersect
- DExclude
How the community answered
(34 responses)- A12% (4)
- B6% (2)
- C6% (2)
- D76% (26)
Community Discussion
No community discussion yet for this question.