Microsoft
70-433 · Question #76
70-433 Question #76: Real Exam Question with Answer & Explanation
Sign in or unlock 70-433 to reveal the answer and full explanation for question #76. The question stem and answer options stay visible for context.
Question
You have two tables named Customer and SalesOrder. In the Customer table you have 1000 customers, of which 900 customers have orders in the SalesOrder table. You execute the following query to list all customers that have had at least one sale. SELECT * FROM Customer WHERE Customer.CustomerID IN (SELECT Customer.CustomerID FROM SalesOrder) You need to identify the results of the query. Which results will the query return?
Options
- ANo rows
- BA warning message
- CThe 1000 rows in the Customer table
- DThe 900 rows in the Customer table with matching rows in the SalesOrder table
Unlock 70-433 to see the answer
You've previewed enough free 70-433 questions. Unlock 70-433 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.